Search code examples
oracle-databaseoracle10g

List the contents of Oracle export dump file

I have an oracle full dump. I know I have to imp the dump with the fromuser touser clause. However I don't know the names of the schemas included in the dump.

how can I open the dump created with Oracle 10g just to check and analyze the content?

Solution

  • Just use the SHOW=Y parameter

    IMP SCOTT/TIGER SHOW=Y FILE=import_file.dmp