How to see imported Oracle tables

Question

Hello. I have oracle dump file from Oracle8. I am trying to import data in Oracle 10. For importing data I am using PL/SQL Developer(buy the way, I have TOAD client). I am doing that by click Tools->Import Tables choose Oracle Import, and then choose Import file. after that click Ok, Done. so How I can find imported tables? I am using "sys" login. Database is located remotely.

UPDATE1 Ok. During importing I got this log

Export file created by EXPORT:V08.01.07 via conventional path
import done in CL8MSWIN1251 character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
. importing MD's objects into MD

*****
Then
"ALTER SESSION .....
....there some sql syntaxes

. . skipping table "MyTable" 
****
WHY it is skipping?
****
end last
Import terminated successfully with warnings. :)

UPDATE2. The Issue was resolved by installing Oracle8 in virtual machine. Import was success.

Answer 1

Imported tables aren't going to be flagged in any particular manner. The import process itself knows what tables are loaded-- if you use the command-line import utility, you can have it generate a log of the objects that are imported. I would expect that your GUI would have a similar log functionality.

I'm hoping that you are not importing the objects into the SYS schema or using SYS for normal day-to-day operations. SYS is a very special, very powerful account. It should be used very rarely and only for a handful of administrative tasks.

Answer 2

Hopefully the export was done as a different user and the objects have not been imported under the SYS schema. Doing that - or pretty much anything - as SYS is generally not advisable as there are a lot of ways you can damage your database.

If you know the original owner of the objects, look under the 'Other users' at the bottom of the schema list for your connection (in the left-hand panel), find and expand that user, and the tables should be in there. I have to add that I haven't imported that way, but with the command-line imp tool you get a warning about importing as a different user and that would tell you the original owner. Was there a log from this import?

Answer 3

You could try to find them by creation time, if you haven't had these tables in your database before:

select object_name, created, last_ddl_time, timestamp
  from all_objects
 where owner = 'SYS'
   and object_type = 'TABLE';

And, yes, as it has already been said, don't use SYS for day-to-day operations. It's not a good practice at all.