Create a schema like an existing schema

Asked Sep 12 '13 at 13:13

Active Sep 12 '13 at 13:13

Viewed 55 times

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?

Thanks

asked Sep 12 '13 at 13:13

Jacob

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 – Mindaugas Riauba Sep 12 '13 at 13:22
You're welcome. Just check object level grants after such cloning. – Mindaugas Riauba Sep 13 '13 at 17:50

0 Answers0