The num_rows field indicate the number of rows at the time of the last
statistics. Do this
SQL>select table_name, num_rows from dba_tables
where num_rows>0;
On retrieving those rows, select count(*) from those tables. This gives
current actual count of records on those tables. It should retrieve zero.

Titus Olowok
Oracle DBA
Atlanta, GA
----- Original Message -----
From: "Deepak Panda "
<oracledba-ezmlmshield-x53693912.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, February 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