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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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: – ipip Sep 6 '13 at 9:01
change your undo_retention parameter – user3556458 Apr 21 '14 at 12:18

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 '14 at 7:32

Your Answer


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.