Copying objects to remote database and modifying so they use the remote database only if the local database is offline
I have created a local database and a database link to a remote database to which I have to copy all my objects. How do I modify the objects to use the remote tables only if the local database is offline? I'm working with Oracle 11g Express and Oracle SQL Developer.