Skip to Content
1
Feb 15, 2012 at 12:00 PM

'invalid table name' in SQL command Editor for tables having slash in name

2971 Views

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