on 02-15-2012 12:00 PM
Hi All,
In SQL command Editor (ST04) I am trying to query a table belonging to some partner namespace
My query looks like this
SELECT count(*) as n from /ABCD/MYTABLE
This error is returned: (ORA-903): ORA-00903: invalid table name
The problem is definitely with the slashes - for other tables it works fine:
SELECT count(*) as n from T001
I tried to escape the slashes with quotes, doublequotes, backslashes - it didn't work.
Is it at all possible to query tables like these?
Thanks in advance!
Best regards,
Egor
Works absolutely fine with me using double quotes...
SELECT count(*) as n from "/ABCD/MYTABLE";
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Eduardo, Juan, Thank you!
My system's patch level has been upgraded recently, and finally I was able to get it to work. The format that worked for me was doublequotes, no owner.
Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Egor,
You can use the following statement:
select count(*) as n from <OWNER>."/ABCD/MYTABLE";
If you don't know the owner you can use the following statement:
select owner from dba_tables where table_name = '/ABCD/MYTABLE ';
Regards,
Eduardo Rezende
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.