Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02156: invalid TEMPORARY tablespace identifier
- 2 Answers
- 23517 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-16718: failed to locate the database resource
ORA-13801: invalid value for SQLTUNE_CATEGORY parameter
ORA-13040: failed to subdivide tile
RMAN-06119: uncataloged datafile copy
DRG-11442: valid gist numParagraphs values are string
ORA-09958: IMON: two processes with the same ORACLE pid are active
CLSR-00511: Error number encountered when handling incoming EVM message
ORA-30478: Specified dimension does not exist
ORA-24378: user callbacks not allowed for this call
ORA-32841: invalid value for property string
ORA-16402: ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
ORA-22298: length of directory alias name or file name too long
Oracle Errors 
