Home » RDBMS Server » Server Utilities » Validation steps (Sun Solaris, Oracle 10.2.0.3)
Validation steps [message #504464] Mon, 25 April 2011 14:17 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Can someone let me know in detail the validation steps which have to be done after doing export/import from one server to another?
Re: Validation steps [message #504466 is a reply to message #504464] Mon, 25 April 2011 14:38 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
-check the import logs
-compare object count and status
Re: Validation steps [message #504467 is a reply to message #504466] Mon, 25 April 2011 14:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
run the application validation tests that the QA group maintains
Re: Validation steps [message #504468 is a reply to message #504466] Mon, 25 April 2011 14:42 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Thanks. To compare object count and status, can I issue the following command. Will that be sufficient?

select count(*) from dba_objects where status='INVALID' and owner in 'XXXXXXXX';

Also If i get the value for the above query in the 1st server to be 5 and the value in the 2nd server also to be 5, can I simply ignore?
Re: Validation steps [message #504469 is a reply to message #504464] Mon, 25 April 2011 14:48 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
just to be sure,,,,match the invalid object names also and not only the count.
Re: Validation steps [message #504470 is a reply to message #504469] Mon, 25 April 2011 14:54 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Surely you should be comparing all objects on name/type and just ignore status completely.
Re: Validation steps [message #504471 is a reply to message #504468] Mon, 25 April 2011 15:44 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Importing surely will give you many more invalid objects in your target I am sure initially.
Plus, it will not tell you if you missed any objects or if a non-matching object already existed with the same name.
I'd go for the import log and testing the application.
Previous Topic: multiple export/import dump files
Next Topic: Automatically generate E-R diagram
Goto Forum:
  


Current Time: Fri Mar 29 01:28:02 CDT 2024