I have a existing schema in my database called SCOTT, how can I create a new schema with exactly the same privileges which SCOTT schema is having?

Is there any create like or some command to create schema like SCOTT?


  • 1
    That quoted answer is too complicated. The simpliest way is to expdp \'/ as sysdba\' schemas=scott and impdp \'/ as sysdba\' remap_schema=scott:brown Sep 12, 2013 at 13:22
  • You're welcome. Just check object level grants after such cloning. Sep 13, 2013 at 17:50


Browse other questions tagged or ask your own question.