Take the 2-minute tour ×

We recently got some errors in our alert log of the form

301598: Tue Jul 16 03:58:29 2013
301599: ORA-01555 caused by SQL statement below 
301600: SELECT * FROM RELATIONAL(<owner>.<table>)

I know how to handle ORA-01555 errors, but I never encountered something like SELECT * FROM RELATIONAL. I looked in DBA_OBJECTS, but there is no such function/operator/whatever.

Googling for 'SELECT * FROM RELATIONAL' only returned questions related to ORA-01555.

So, my question is: What is the meaning of the RELATIONAL keyword here?

share|improve this question
It seems that this is something deeply internal. Because support.oracle.com also shows only the same information that you already googled. –  Mindaugas Riauba Jul 18 '13 at 13:56
I am 99% certain this is for querying the XMLTYPE datatype, but I can't find the reference as obviously relational is a very difficult word to search DB documentation for. –  Gaius Jul 25 '13 at 11:02
@Gaius I don't think it's XMLTYPE related (the table doesn't contain an XMLTYPE column). –  Frank Schmitt Jul 25 '13 at 11:19
Found this, might help: forums.oracle.com/thread/1042943?start=0&tstart=0 –  ipip Sep 6 '13 at 9:01
add comment


Your Answer



Browse other questions tagged or ask your own question.