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-15011: failure group "string" contains no members

RMAN-06187: controlfile copy string not found or out of sync with catalog

ORA-01079: ORACLE database was not properly created, operation aborted

QSM-02092: mv references a sequence number

ORA-02722: osnpui: cannot send break message to orapop

ORA-01169: DATAFILE number 1 not found. Must be present

ORA-36882: (XSSRF01) The second parameter of an AW single row function cannot be NULL.

QSM-02132: agg(expr) requires correspondng COUNT(expr) function

ORA-16021: session string destination cannot be the same as session string destination

ORA-24438: Invalid Authentication Handle specified.

ORA-01684: max # extents (string) reached in table string.string partition string

ORA-31419: source table string does not exist

For more Oracle Errors Interview Questions Click Here