Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02156: invalid TEMPORARY tablespace identifier
- 2 Answers
- 23691 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 |
NID-00302: Datafile string - dbid changed
NNO-00629: warning: invalid forwarder list, no default forwarders loaded
ORA-25952: join index must only contain inner equi-joins
ORA-06721: TLI Driver: spurious client req
ORA-13604: The specified parameter string cannot be fetched as a SQL table.
SQL*Loader-00652: Invalid zoned decimal byte.
ORA-19201: Datatype not supported
ORA-29387: no top-plans found in the pending area
ORA-39139: Data Pump does not support XMLSchema objects. string will be skipped.
SQL*Loader-00514: Error getting elapsed time
TNS-00504: Operation not supported
KUP-03015: OCI error getting datetime lfprecision.
Oracle Errors 
