Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02156: invalid TEMPORARY tablespace identifier
- 2 Answers
- 23675 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-01568: cannot set space quota on PUBLIC
ORA-38459: XML Tag "string" not found for the XMLType attribute "string"
LFI-00119: Unable to Abort an Unprotected file.
PLS-00500: invalid operator binding
ORA-31644: unable to position to block number string in dump file "string"
NZE-29242: the asymmetric key is too short to be used with the data.
ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes
LSX-00222: "~1S" is too long (maximum length is ~2d)
ORA-29550: Java session state cleared
PLS-00324: cursor attribute may not be applied to non-cursor 'string'
NZE-29232: the cryptographic engine key initialization failed
DRG-11118: object string does not exist
Oracle Errors 
