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-36714: (XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.

1 Answers  


ORA-12732: invalid interval value in regular expression

1 Answers  


IMG-00833: boundary queue size exceeds expected size

1 Answers  


ORA-16222: automatic Logical Standby retry of last action

1 Answers  


TNS-00508: No such protocol adapter

1 Answers  






ORA-39045: invalid metadata remap name string

1 Answers  


ORA-31626: job does not exist

1 Answers  


LPX-00270: FTP error: ~s

1 Answers  


SQL*Loader-00474: no value set for dynamic file for column string in table string row number

1 Answers  


TNS-12625: TNS:missing argument

1 Answers  


ORA-24785: Cannot resume a non-migratable transaction

1 Answers  


ORA-01955: DEFAULT ROLE 'string' not granted to user

1 Answers  


Categories