I'm importing a dump using an 11g client to a 10g database. I'm using this command:
IMP userid=user/pass@DB fromuser=user touser=user file=file.dmp constraints=n ignore=y indexes=n TABLES=TABLE_NAME log=log.txt
Before I import the table, I drop the table first. Running the command above will give me a how many rows were imported. i.e., 2000 rows imported.
But when I query the table row count using the script below, it doesn't match the row count reported. How is this possible?
select table_name, num_rows counter from dba_tables where table_name = 'TABLE_NAME'
The only errors I see are related to grants and constraints.
Your help will be appreciated. Thanks.
num_rows in the table DBA_TABLES is filled when you run statistics, it is not updated due to insert/updates/deletes. So run statistics though DBMS_STATS on the table and they should be more in sync.
Herald ten Dam