I would say use this order:
1. create the new tables (and make sure they are correct)
2. make sure that the dblink works
3. drop the source tables
4. create synonyms that use the dblink to replace the source tables
5. recompile any/all invalid views
You should be aware that performance of these tables over a dblink will
likely be 10-1000x slower than when they were local. Depending on the
data volumes and the frequency of the access over the dblink, this may
or may not be a problem.
-----Original Message-----
From: Dustin Hayden
[mailto:oracledba-ezmlmshield-x9914594.[Email address protected]
Sent: Wednesday, January 31, 2007 11:22 AM
To: LazyDBA Discussion
Subject: Spam: drop table question
I want to move some tables from one database to another. (9.2.05)
I will build the new tables in the remote database and then I plan to
drop the tables on the source(all tables are currently empty) and create
synonyms that use a dblink to point to the tables location on the remote
database.
My question is if some of these tables have view that reference them
should I rename the tables first and create the synonyms and then drop
the table or it it ok to just drop them first and create the synonyms?
TIA.
Dustn
---------------------------------------------------------------------
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
THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.
Oracle LazyDBA home page