ORA-12902: default temporary tablespace must be SYSTEM or of
TEMPORARY type



ORA-12902: default temporary tablespace must be SYSTEM or of TEMPORARY type..

Answer / guest

Cause: in a dictionary managed database, default temporary
tablespace must be SYSTEM or TEMPORARY type

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24033: no recipients for message

1 Answers  


ORA-31108: Action failed as resource string is locked

1 Answers  


ORA-30755: error during expansion of view hierarchy

1 Answers  


ORA-19571: %s recid string stamp string not found in controlfile

1 Answers  


ORA-31630: a job name is required to attach a job for user string

1 Answers  






ORA-23373: object group "string"."string" does not exist

1 Answers  


SQL*Loader-00121: Invalid skip_unusable_indexes option

1 Answers  


ORA-31686: error creating worker processes

1 Answers  


ORA-07645: sszfsl: $CHANGE_CLASS failure

1 Answers  


ORA-39951: incomplete values specified for PL/SQL warning settings

1 Answers  


ORA-19668: cannot do full restore of datafile string

1 Answers  


QSM-00779: the specified directive conflicts with the existing directive string

1 Answers  


Categories