Okay, so I need import a full .dmp into a new (empty) db. I am not familiar with the tablespaces or users of the db to be imported. At all. I simply need to get it onto the PC for the db programmer. So, my questions are:
How do I import if I am not sure of the tablespaces or users necessary?
What are the sql commands to create the db?? (CREATE DATABASE "name") Can I do this without any parameters...and keep it from using default parameters?
Is it possible to simply import into a parameter-less db that I create?
I have a clean slate...new machine...newly installed oracle 8i...no other db in sight. Please help. Thank you so much.
(see thread in DBA forum: "Easy Import" for background info)
Click Here to Expand Forum to Full Width