Hi,

I will suggest you:

Generate a create script the application user(s)
Take count of users on the old database, their privileges and roles.
Note the various object statuses especially for your application.
Ensure your export went successful.
Compare stats after the import.
And recompile database objects




Ug
King's Kid - Jesus is Lord
-----Original Message-----
From: Chitra
[mailto:oracledba-ezmlmshield-x97548952.[Email address protected]
Sent: Wednesday, August 30, 2006 12:32 PM
To: LazyDBA Discussion
Subject: Oracle full database dump




Have a doubt, I have a situation where want change my database server
to
new one, I.e. from server A to Server B, I will doing fresh (oracle
server)
installation on server B and then I will import my old database to
Server
B, What precaution should I take while doing so???


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


NOTE: This e-mail message is subject to the MTN Nigeria disclaimer see http://www.mtnonline.com/contact/disclaimer.asp



Oracle LazyDBA home page