ORA-12900: must specify a default temporary tablespace for a
locally managed database



ORA-12900: must specify a default temporary tablespace for a locally managed database..

Answer / guest

Cause: a locally managed database must have a temporary
tablespace other than SYSTEM tablespace

Action: specify the default temporary tablespace when
creating a locally managed database

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11722: invalid language specification

1 Answers  


NNL-00547: Displays rename request statistics

1 Answers  


ORA-16110: user procedure processing of logical standby apply DDL

1 Answers  


ORA-28290: Multiple entries found for the same Kerberos Principal Name

1 Answers  


ORA-02820: Unable to write the requested number of blocks

1 Answers  






RMAN-06123: operation not supported without the recovery catalog or mounted controlfile

1 Answers  


ORA-36212: (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.

1 Answers  


ORA-12315: database link type is invalid for the ALTER DATABASE statement

1 Answers  


QSM-01090: no query rewrite after view merging

1 Answers  


ORA-02809: Jump buffer not valid

1 Answers  


ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 Answers  


QSM-01014: top level operator in WHERE clause of the query is an OR

1 Answers  


Categories