ORA-12901: default temporary tablespace must be of TEMPORARY type

ORA-12901: default temporary tablespace must be of TEMPORARY
type

Question Posted / guest

ORA-12901: default temporary tablespace must be of TEMPORARY type..

Answer / guest

Cause: in a locally managed database, default temporary
tablespace must be TEMPORARY type

Action: none

Please add more information about this Error

Is This Answer Correct ?

0 Yes

2 No

More Oracle Errors Interview Questions

ORA-24812: character set conversion to or from UCS2 failed

PLS-00225: subprogram or cursor 'string' reference is out of scope

ORA-16794: Database Guard is ON for primary database

ORA-06123: NETTCP: cannot set KEEPALIVE

ORA-06303: IPA: Message send error

RMAN-07500: searching for all files that match the pattern string

ORA-24345: A Truncation or null fetch error occurred

TNS-04010: Command cannot be issued before the ADMINISTER command.

KUP-03004: absolute end (number) specified with relative start (number) for field string

ORA-19901: database needs more recovery to create new incarnation

AMD-00132: dimension #string: RDBMS GID column data type not specified

NNL-01078: Access/Create File Error : string

For more Oracle Errors Interview Questions Click Here