ORA-02156: invalid TEMPORARY tablespace identifier
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 |
TNS-00524: Current operation is still in progress
TNS-01153: Failed to process string: string
ORA-12546: TNS:permission denied
PLS-00148: Only 1 pragma of this type is allowed per subprogram
PCB-00557: USING clause can only be used on a PREPAREd dynamic statement
TNS-12150: TNS:unable to send data
ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE
DRG-11435: primary key value is invalid
LSX-00341: ENTITY or ENTITIES type may only be used in attributes
RMAN-08085: created script string
what is error treshold?
NNO-00633: detected fatal delegation loop involving server "string"