So my issue today is I am trying to create a materialized view using information for a remote db. My credentials to access the remote database is fine as well as the database link used to create the materialized view. It is just when I actually try to create it I get an error stating
CREATE MATERIALIZED VIEW "schema"."table"
ERROR at line 1:
ORA-00942: table or view does not exist
Now when it says "table or view does not exist" not entirely sure what it is referring to (still learning oracle) because I created a table with that exact same name. And obviously the view does not exist because that's what I'm trying to make.
Little more background, the database I am working on is a migrated one meaning the old db was oracle 10g and I migrated it over to 11g. 10g is still online "so to speak" meaning I can use it for reference purposes. I matched everything up and still nada, any help would be appreciated.
It's also sitting on top of a windows 2008 r2 x64 server OS