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-31658: specifying a schema name requires a table name

1 Answers  


ORA-02783: Both post and wait functions were not specified

1 Answers  


ORA-15031: disk specification 'string' matches no disks

1 Answers  


CLSR-00527: OCR operation failed

1 Answers  


RMAN-08132: WARNING: cannot refresh aged file list

2 Answers  






LSX-00168: referring form of "~S" must NOT occur at the top level

1 Answers  


RMAN-06186: PL/SQL package string.string version string in string database is too old

1 Answers  


ORA-00956: missing or invalid auditing option

1 Answers  


ORA-01332: internal Logminer Dictionary error

1 Answers  


NNO-00712: warning: group string cache checkpoint failed

1 Answers  


ORA-16700: The standby database has diverged from the primary database.

1 Answers  


ORA-22983: not a user-defined REF

1 Answers  


Categories