Database

View All Threads First Prev Next

Oracle Application expres Fred Andres6-Jan-13 11:52 Fred Andres 6-Jan-13 11:52  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? Re: Oracle Application expres Chris Meech6-Jan-13 13:57 Chris Meech 6-Jan-13 13:57  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] Re: Oracle Application expres Fred Andres7-Jan-13 8:32 Fred Andres 7-Jan-13 8:32  Thanks. That worked. Re: Oracle Application expres Shameel7-Jan-13 3:45 Shameel 7-Jan-13 3:45  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. Re: Oracle Application expres Fred Andres7-Jan-13 8:32 Fred Andres 7-Jan-13 8:32  Thanks for the help. Chris' solution worked.

Last Visit: 31-Dec-99 18:00     Last Update: 23-Apr-24 12:34 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.