| Validation steps [message #504464] |
Mon, 25 April 2011 14:17  |
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 #504468 is a reply to message #504466] |
Mon, 25 April 2011 14:42  |
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 #504471 is a reply to message #504468] |
Mon, 25 April 2011 15:44 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
