• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

imp utility (full import)

i created a fresh new db and have to do a full import from a dump file . Export was done using exp utility.

Inorder to do a full import, i need to firsh create user schemas,tablespaces of export dump file ,

how can i extract the user schemas and created them before before importing...thanks ...

i know about imdp, but this is using imp utility.
  • 2
1 Solution
slightwv (䄆 Netminder) Commented:
Its been a long time since I did a FULL import.  Are you cure a FULL won't create users?

Anyway, use the SHOW=Y and INDEXFILE parameters.  The indexfile should show all the commands (they should be commented out).

If that doesn't work, use logfile with show=Y.  It will require more editing to ger executable.
Dba_Oracledb2Author Commented:
i will try that, imp will not create user for a full import for sure...thanks..
slightwv (䄆 Netminder) Commented:
Just tested with my XE database.  Indexfile doesn't appear to have the user info.

The logfile does have the create user statements.  Since it does, this means it would create them on a full import.

My guess is the export that created the file wasn't a full export.

If you don't have a complete list of from and to schemas to pre-create then I only know of the brute-force approach and manually go through the log file looking for them.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now