Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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
2  
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
2  
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
1  
@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
1  
Found this, might help: forums.oracle.com/thread/1042943?start=0&tstart=0 –  ipip Sep 6 '13 at 9:01
add comment

1 Answer

The line below "ORA-01555 caused by SQL statement below " is the SQL Statement causing the UNDO to swap.

So RELATIONAL is not an Oracle thing, it is an object created by a user. It is a function with owner.table parameter.

share|improve this answer
    
If it were a function created by a user, shouldn't it be present in DBA_OBJECTS? –  Frank Schmitt Apr 10 at 7:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.