Deepak,

You should be seeing a misleading info. When you imported the schema
(with no data), the STATISTICS got imported too. You should import with
STATISTICS=recalculate or just analyze the schema to get rid of this
dirty old information.

Hope this helps!

-Aliyar Sahib
WashingtonDC



"Deepak Panda "
<oracledba-ezmlms
hield-x53693912.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
02/24/2005 12:11
AM Subject
Import problem










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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




Oracle LazyDBA home page