ORA-02156: invalid TEMPORARY tablespace identifier

Answers were Sorted based on User's Feedback



ORA-02156: invalid TEMPORARY tablespace identifier..

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

ORA-02156: invalid TEMPORARY tablespace identifier..

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

Post New Answer

More Oracle Errors Interview Questions

TNS-00524: Current operation is still in progress

1 Answers  


TNS-01153: Failed to process string: string

1 Answers  


ORA-12546: TNS:permission denied

1 Answers  


PLS-00148: Only 1 pragma of this type is allowed per subprogram

1 Answers  


PCB-00557: USING clause can only be used on a PREPAREd dynamic statement

1 Answers  






TNS-12150: TNS:unable to send data

1 Answers  


ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 Answers  


DRG-11435: primary key value is invalid

1 Answers  


LSX-00341: ENTITY or ENTITIES type may only be used in attributes

1 Answers  


RMAN-08085: created script string

1 Answers  


what is error treshold?

1 Answers  


NNO-00633: detected fatal delegation loop involving server "string"

1 Answers  


Categories