1 Reply Latest reply: Oct 14, 2013 5:17 AM by Herald ten Dam RSS

    Rows imported don't match the table row count

    12d95f38-da54-4384-9342-18dc532e3971

      Hello,

       

      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.