|
I imported a table called sales to my Oracle database from Access. When I look in the Oracle Application Express object browser, I see the table and I can open it and see the design and the data. However, when I enter the query - select * from sales - I get the error message ORA-00942: table or view does not exist. What am I doing wrong?
|
|
|
|
|
Try granting permissions to the table following the import.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
The table might have been imported to a different schema, try prefixing the table name with the schema name in the query. Or as Chris Meech suggested, check for permissions.
|
|
|
|
|
Thanks for the help. Chris' solution worked.
|
|
|
|