Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02156: invalid TEMPORARY tablespace identifier
- 2 Answers
- 23679 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-10573: Test recovery tested redo from change string to string
ORA-13839: V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
ORA-38435: missing elementary attribute value or invalid name-value pairs
ORA-29510: name, string.string, already used by an existing object
QSM-02152: subquery or named view in FROM list even after view merging
ORA-02207: invalid INITRANS option value
DRG-11444: valid gist maxPercent values are string
ORA-07590: spdde: $DELPRC failure
ORA-25243: CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
ORA-27039: create file failed, file size limit reached
RMAN-05512: tablespace string cannot be skipped from duplication
ORA-25956: join index cannot be created on tables owned by SYS
Oracle Errors 
