Dear DBAs,

I wanted to copy one schema to another without data. I exported the source schema data using

exp system/manager owner=user1 file=d:\backup\user1.dmp rows=n consistent=y log=d:\backup\user1.log

Then I created the new destination schema user2.

And imported from export created above

imp system/manager touser=user2 fromuser=user1 rows=n grants=y file=d:\backup\user1.dmp

But When I queried user2 schema

SQL> select count(*) from user_tables where num_rows>0;


COUNT(*)
---------
67

Please tell me how/why did this happen. Did I do wrong somewhere? I am using Oracle 9i R1.

Looking forward to your valuable inputs.

Regards

Deepak

Oracle LazyDBA home page