I need to export list of tables from the source database into target(test) database.
I have done a export into a dump file.
I am importing it into a test database and we get a list of tables that are imported on the screen. My question is: Is there a way to see list of tables that still need to be imported from the dump file? If so, could you please let us know how can this be achieved?
It would be easier to read the log file than the dmp file. It's a lot smaller, too. As for the tables being listed in alphabetical order, this is true. However, remember that one schema is imported/exported at a time, so the order is by schema, then alphabetical.