ORA-02156: invalid TEMPORARY tablespace identifier
Answers were Sorted based on User's Feedback
Answer / guest
alter user user1 temporary tablespace 'ts_tmp1'; --wrong
alter user user1 temporary tablespace ts_tmp1; --correct
We don't wrap it in single quotation marks to tablespace name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
Cause: An identifier does not follow TEMPORARY TABLESPACE.
Action: Place a tablespace name after TEMPORARY TABLESPACE.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 2 No |
ORA-09318: slkhst: unable to host out to operating system
ORA-37070: You may not execute OLAP DML programs in a parallel query session.
ORA-08467: error converting Oracle number to string
ORA-31010: XML element index string exceeds maximum insertion index string
PLS-00373: EXIT label 'string' must label a LOOP statement
ORA-32639: Aggregate functions on reference MODELs are not allowed
DRG-11817: Proxy Redirect
ORA-07207: sigpidu: process ID string overflows internal buffer.
ORA-29340: export file appears to be corrupted: [string] [string] [string]
SQL*Loader-00655: cannot load object-relational XML attribute using direct path
ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
ORA-36650: (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.