Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02156: invalid TEMPORARY tablespace identifier
- 2 Answers
- 23826 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-16066: remote archival disabled
ORA-28523: ORACLE and heterogeneous agent are incompatible versions
QSM-02062: GROUP BY clause in mv
ORA-01716: NOSORT may not be used with a cluster index
ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
ORA-16201: Skip procedure requested to apply statement
ORA-22064: invalid NLS parameter string [string]
SQL*Loader-00274: At least 2 read buffers have to be specified.
TNS-01044: %s(Registered) has string service handler(s)
NNO-00854: error unbinding LDAP: error = number
QSM-01034: materialized view, string, needs a dimension level to join table, string
ORA-01058: internal New Upi interface error
Oracle Errors 
