Link to home
Start Free TrialLog in
Avatar of Dba_Oracledb2
Dba_Oracledb2

asked on

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.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
Avatar of Dba_Oracledb2

ASKER

i will try that, imp will not create user for a full import for sure...thanks..
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial