1

After importing a oracle dump, the log file tells me that 86643 rows were imported; however, when I use sql developer and FME to retrieve the tables row count, only 86,198 rows are shown. What would cause this inconsistency?

MelBuske
  • 11
  • 1
  • do you have any triggers? how about scheduled jobs? users on the system? these are all things that could be deleting records – thatjeffsmith Nov 16 '18 at 15:01

1 Answers1

0

There could be tables imported in other schema. Run the below query to get more extensive list of tables in the database check if that matches your expected count.

Select * from all_tables;
Ashok Vanam
  • 1