ORA-36712: (XSMXALLOC02) Relation workspace object must be a
one-dimensional self-relation to be used as a SOURCE or
BASIS with ALLOCATE.



ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be us..

Answer / guest

Cause: The user specified an invalid source or basis
relation on the ALLOCATE command line.

Action: Modify the relation to be a one-dimensional
self-relation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06504: PL/SQL: Return types of Result Set variables or query do not match

1 Answers  


ORA-12983: cannot drop all columns in a table

1 Answers  


PCC-02412: FOR clause not permitted in OBJECT GET or SET statement

1 Answers  


NPL-00420: received ASN.1 object identifier with more than 256 sub-identifiers

1 Answers  


ORA-02282: duplicate or conflicting ORDER/NOORDER specifications

1 Answers  






ORA-30752: column or table string is not substitutable

1 Answers  


QSM-02186: PARTITIONED OUTER JOIN is present

1 Answers  


ORA-12524: TNS:listener could not resolve HANDLER_NAME given in connect descriptor

1 Answers  


ORA-25956: join index cannot be created on tables owned by SYS

1 Answers  


QSM-02028: group by CUBE

1 Answers  


NZE-29035: Pseudo Random Number Generator is needed

1 Answers  


ORA-01486: size of array element is too large

1 Answers  


Categories