Table doesn't exist? [message #312605] |
Wed, 09 April 2008 07:24  |
stefanc
Messages: 3 Registered: April 2008
|
Junior Member |
|
|
Hi,
When I'm trying to execute the following query, i'm getting this error: ORA-00942: table or view does not exist
Offcourse, I did made this table, and added some data to it. Also I executed a query to check if the table exists by showing all the tables from the database.
Anyone knows what I'm doing wrong here?
Help is much appreciated,
Stefan
|
|
|
|
|
Re: Table doesn't exist? [message #312611 is a reply to message #312605] |
Wed, 09 April 2008 07:38   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
stefanc wrote on Wed, 09 April 2008 08:24 | Also I executed a query to check if the table exists by showing all the tables from the database.
|
And what did that show? Is it in another schema? Are you sure you are connecting to the same database where you created the table?
It could that be someone else has dropped this table.
|
|
|
|
|
Re: Table doesn't exist? [message #312722 is a reply to message #312611] |
Wed, 09 April 2008 11:54   |
stefanc
Messages: 3 Registered: April 2008
|
Junior Member |
|
|
joy_division wrote on Wed, 09 April 2008 07:38 | stefanc wrote on Wed, 09 April 2008 08:24 | Also I executed a query to check if the table exists by showing all the tables from the database.
|
And what did that show? Is it in another schema? Are you sure you are connecting to the same database where you created the table?
It could that be someone else has dropped this table.
|
That was this query with the following result:
Quote: | select * from user_objects where object_type = 'TABLE';
|
OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY
Artists - 13841 13841 TABLE 09-APR-08 09-APR-08 2008-04-09:12:30:35 VALID N N N
With some more irrelevant rows. I also tried the query posted here, which resulted in 'no data found' error.
I'm working in the webbrowser, logged in as 'Deejay' when creating the tables AND running all these queries.
[Updated on: Wed, 09 April 2008 11:55] Report message to a moderator
|
|
|
|
|
Re: Table doesn't exist? [message #312748 is a reply to message #312738] |
Wed, 09 April 2008 13:00  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
As I said Oracle works by default with upper case identifier.
To work with mixed you have to enclose name with " like "Artists" but it is a bad practice.
Regards
Michel
|
|
|