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


Oracle LazyDBA home page