Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02156: invalid TEMPORARY tablespace identifier
- 2 Answers
- 23812 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-01258: unable to delete temporary file string
ORA-27544: Failed to map memory region for export
DRG-10709: this preference is referenced by string and cannot be dropped
PLS-00669: Type of expression should be a valid collection variable
ORA-22921: length of input buffer is smaller than amount requested
ORA-00021: session attached to some other process; cannot switch session
ORA-00911: invalid character
LPX-00283: document encoding is ~s-based but default input encoding is not
ORA-01353: existing Logminer session
ORA-30196: reserved for future use
ORA-13039: failed to update spatial index for element string.string.string
ORA-07633: smsdbp: illegal protection value
Oracle Errors 
