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

ORA-36874: (XSFTDSC04) Expression string cannot be used to define a column in a LIMITMAP.

1 Answers  


ORA-00706: error changing format of file 'string'

1 Answers  


EXP-00000: Export terminated unsuccessfully

1 Answers  


TNS-00147: Failed to start a pre-spawned pump.

1 Answers  


PLS-00411: Number of values in aggregate and in subquery don't match

1 Answers  






PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE

1 Answers  


ORA-01650: unable to extend rollback segment string by string in tablespace string

1 Answers  


ORA-29702: error occurred in Cluster Group Service operation

1 Answers  


ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported

1 Answers  


ORA-38737: Expected sequence number string doesn't match string

1 Answers  


ORA-32408: materialized view log on "string"."string" already has new values

1 Answers  


ORA-29847: cannot create a local domain index on a partitioned index-organized table

1 Answers  


Categories