Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02156: invalid TEMPORARY tablespace identifier
- 2 Answers
- 23563 Views
- I also Faced
- E-Mail Answers
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-39061: import mode string conflicts with export mode string
ORA-13903: Invalid combination of string threshold value and operator.
ORA-16182: Internal error on internal channel during remote archival
ORA-14122: only one REVERSE or NOREVERSE clause may be specified
ORA-12449: Labels specified for user must be of type USER
KUP-04069: error fetching data for external table
ORA-16228: Insufficient recovery for logical standby
ORA-01517: log member: 'string'
ORA-02155: invalid DEFAULT tablespace identifier
TNS-02520: encryption/crypto-checksumming: no Diffie-Hellman seed
TNS-00045: INTCTL: Could not contact the Navigator on address
ORA-06258: NETNTT: cannot allocate context area
Oracle Errors 
