external table - ORA -00942 table or view doesn't exist.
_AZ_Jan 16 2008 — edited Apr 6 2009I created all possible locations ( in the Connection Explorer ).
Created a flat file modules and imported the the metadata about flat file.
i'm able to create an external table - it get populated with the correct metadata about columns from the flat file module, but i'm unable to to access the data by right clicking on the ext table name and selecting that submenu....
The design center and deploy location are on the same DB, but in different schemas.
I searched through the forum extensively, but haven't been able to find the solution.
Please advise.
thank you.
Andrew