Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
OWB- ora-00942: table or view does not exist EVEN if the table exist
- Thread starter oracle70
- Start date
SantaMufasa
Technical User
Francis,
Please post the results of this query:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE UPPER(object_name) like '%some_upper_case_chrs_in_name%';
...then isolate for us which entry is the one you want.
Dave
Sandy, Utah, USA @ 18:04 GMT, 11:04 Mountain Time
Please post the results of this query:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE UPPER(object_name) like '%some_upper_case_chrs_in_name%';
...then isolate for us which entry is the one you want.
Dave
Sandy, Utah, USA @ 18:04 GMT, 11:04 Mountain Time
Francis, according to my own experience appr. 70% of cases with "virtual" tables are resolved by referencing those tables "correctly": by using fully qualified names or by creating synonyms or altering session to change current schema. So, in fact they're just tables from another schema 
Another 30% (the number grows as more applications are migrated from Access) are case-related, though may be cured by renaming them during migration or enclosing their exact names by doublequotes.
Check also whether your application connects to database as the same user you check your table existence under.
Regards, Dima
Another 30% (the number grows as more applications are migrated from Access) are case-related, though may be cured by renaming them during migration or enclosing their exact names by doublequotes.
Check also whether your application connects to database as the same user you check your table existence under.
Regards, Dima
- Thread starter
- #4
Hi,
When I went through the code in SQL*Navigator and replaced all those "dkdkdk" table refereneces and db links with the REAL TABLE NAME, IT COMPILES.
AS FOR THAT QUERY WHAT SOULD I SUBSTITUE FOR
some_upper_case_chrs_in_name????
REGARDS,
cHANNA.
When I went through the code in SQL*Navigator and replaced all those "dkdkdk" table refereneces and db links with the REAL TABLE NAME, IT COMPILES.
AS FOR THAT QUERY WHAT SOULD I SUBSTITUE FOR
some_upper_case_chrs_in_name????
REGARDS,
cHANNA.
SantaMufasa
Technical User
Francis/Channa,
By "some_upper_case_chrs_in_name" I mean choose a few sequential characters from the name of the table for which you are looking. For example, the table you KNOW exists has the name "TFB_CUSTOMER_ACCT_INFO", then code the SELECT as:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE UPPER(object_name) like '%CUST%';
That query should print out the name of your table, plus the names of any other table with the string "CUST" anywhere in the table name. I'm just try to see if there is anything extraordinary about the name of your "missing" table.
Dave
Sandy, Utah, USA @ 06:05 GMT, 23:05 Mountain Time
By "some_upper_case_chrs_in_name" I mean choose a few sequential characters from the name of the table for which you are looking. For example, the table you KNOW exists has the name "TFB_CUSTOMER_ACCT_INFO", then code the SELECT as:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE UPPER(object_name) like '%CUST%';
That query should print out the name of your table, plus the names of any other table with the string "CUST" anywhere in the table name. I'm just try to see if there is anything extraordinary about the name of your "missing" table.
Dave
Sandy, Utah, USA @ 06:05 GMT, 23:05 Mountain Time
- Status
Similar threads
