ORA-03212: Temporary Segment cannot be created in
locally-managed tablespace



ORA-03212: Temporary Segment cannot be created in locally-managed tablespace..

Answer / guest

Cause: Attempt to create a temporary segment for
sort/hash/lobs in in permanent tablespace of kind
locally-managed

Action: Alter temporary tablespace of user to a temporary
tablespace or a dictionary-managed permanent tablespace

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-50948: ABOUT clause required in the absence of a text index

1 Answers  


ORA-13449: GeoRaster metadata ULTCoordinate error

1 Answers  


RMAN-10030: RPC call appears to have failed to start on channel string

1 Answers  


ORA-25448: rule string.string has errors

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  






ORA-31110: Action failed as resource string is locked by name

1 Answers  


LPX-00309: cannot initialize XPATH

1 Answers  


ORA-01685: max # extents (string) reached in index string.string partition string

1 Answers  


ORA-06905: CMX: connect error

1 Answers  


RMAN-06125: error while looking up archive log key: number

1 Answers  


EXP-00085: The previous problem occurred when calling string.string.string for object number

1 Answers  


NNL-00894: Requests refused, permission denied: number

1 Answers  


Categories