| Need help in writing pl/sql query [message #230153] |
Wed, 11 April 2007 01:37  |
sibgat
Messages: 45
Registered: November 2006
Location: Chennai
|
Member |
 
|
|
I am regularly doing onsite and offshore db script comparison, which i think can be programmed, can you help me in that.
my task is
comparing table columns,datatype, size, nullable, view,indexes, constraints.. etc to see whether it is in sync with the onsite
db script. which we recieve.
my idea is to execute the onsite script on a separate schema and to compare this with offshore schema through a pl/sql program
i thought user_tab_cols has more or less all the columns which i am usually using it. just i need a program to iterate through the
offshore tables,columns,datatype,size,nullable,views,indexes,constraints and compare all this with onsite script which will be loaded
in another schema and the differences needs to be written to a file(may be text file).
If you could help me on this it would be of great help
Thanks in advance
Regards
sibghat
|
|
|
|
| Re: Need help in writing pl/sql query [message #230163 is a reply to message #230153] |
Wed, 11 April 2007 02:10  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Why doing things when so much already exist?
Many tools allow you to export metadata: OEM, TOAD, DB Artisan and so on.
If you want to code, you can use DataPump with metadataonly option or dbms_metadata package.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
