Home » RDBMS Server » Server Administration » How would i know the usernames in the dump file
How would i know the usernames in the dump file [message #220943] Thu, 22 February 2007 17:08 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

I have database dump file of size 13GB which was taken from Production database.which is a backup of two schemas in the same dump file.

Now i would like to restore the database on our test servers..

How would i know the usernames for both the schemas in the database dump before i start restoring the database.

or What can i mention for the parameters fromuser=,touser=

Please help in this..

Thank you

Re: How would i know the usernames in the dump file [message #220945 is a reply to message #220943] Thu, 22 February 2007 17:43 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
do a dummy import using show=y.
imp user/pass file=myfile.dmp show=y log=somelog.log rows=n 

THis will not acutally do any import. but will dump all the ddl into somelog.log.
You will find your information over there.
Previous Topic: TNS-12541, Connecting to server on the same subnet
Next Topic: Cannot stop or kill backup job
Goto Forum:
  


Current Time: Fri Dec 09 02:23:14 CST 2016

Total time taken to generate the page: 0.14999 seconds