The question is: Is it a feasible solution to have views/materialized views created in one database and have them...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
access 50 tables in another database through db link, considering that there will be DMLs happening every day?
As for the MV's…I would not create a MV which uses remote tables. Instead, I'd create the MV in the remote database. Then I'd use the db link to see the MV in the remote database.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.