I have to transfer a oracle 8i database to another machine.
Recreation of all tables/views/users ...
There is a problem this database acts as a reference DB, so other db's are connected and they have views/synonyms on this DB.
How can I see which table/views are used by other DB, without checking every DB?
So that I also can recreate these views/synonyms.
If the hardware platform you are moving to is the same there should be no problem with this. Do you keep the reference DB open 24/7 or do you have a predefined window to close it down for backups/maintainance. If so you should be able to move it and simply update the additonal servers with the new tns alias.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
We will take the proccessing down, and there both HP-UNIX systems.
You have a table on machine A.
Machine B as a view on that table on machine A.
Is there a way to see only at machine A that there 's a view on machine B?
Last edited by wstroop; 01-09-2003 at 09:24 AM.
Click Here to Expand Forum to Full Width