-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|