Import full database
hi, Iam having full database export file, the database contains 10 users. Now I have installed oracle on new PC by creating new database.
Question: I have created 10 users in new database. Can I import do import by the syntex shown below
imp system/newsystem file=olddb.dmp full=y log=newdb.log
or do i have to use fromuser touser clause by typing all the 10 user names.
Prompt response is highly appreciated.
what happened when you tried it?
if you are planning to do a full import, why bothering with creating individual accounts?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
we already discussed this last week, didn't we?
Click Here to Expand Forum to Full Width