-
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?
-
we already discussed this last week, didn't we?