Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-00208: number of controlfile names exceeds limit of string

1 Answers  


NZE-29223: Cannot create certificate chain.

1 Answers  


ORA-23452: flavor string of object group "string"."string" is already published

1 Answers  


ORA-06779: TLI Driver: error reading ccode

1 Answers  


ORA-30444: rewrite terminated by the sql analyzer

1 Answers  






ORA-29312: changes by release string cannot be used by release string, type: string

1 Answers  


ORA-38951: Target platform string not cross platform compliant

1 Answers  


ORA-09317: szprv: insufficient privileges

1 Answers  


ORA-38423: Attribute set created from an ADT may not be extended.

1 Answers  


ORA-36984: (XSRELGID04) A value cannot be inserted into dimension workspace object.

1 Answers  


ORA-02375: conversion error loading table string.string partition string

1 Answers  


ORA-26517: materialized view control entry for 'string.string' was not found

1 Answers  






Categories