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.
Dba_Oracledb2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
0
Dba_Oracledb2Author Commented:
i will try that, imp will not create user for a full import for sure...thanks..
0
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.