I am using oracle 10g. I am trying to import a DMP file and at the load message it shows scott.SYS_IMPORT_SCHEMA_01 is loaded. But I am not able to find that table in SQLDeveloper or query in it SQLPlus. When I query a select statement from that table it says "Table or view doesn not exist". Please help with any ideas or thoughts.
So the correct way to access the tables of 'scott' will be:
SQL> SELECT * FROM user_tables;
Now you will see all tables of the scott schema.
If I mistaken your question, then see the Import log. It will display you which tables are imported and if there are errors.