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

Report message to a moderator

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: 10707
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.

Report message to a moderator

Previous Topic: TNS-12541, Connecting to server on the same subnet
Next Topic: Cannot stop or kill backup job
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:37:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.