ORA-01662: tablespace 'string' is non-empty and cannot be
made temporary



ORA-01662: tablespace 'string' is non-empty and cannot be made temporary..

Answer / guest

Cause: Tried to convert a non-empty tablespace to a
temporary tablespace

Action: To drop all the objects in the tablespace.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07441: function address must be aligned on string byte boundary

1 Answers  


DRG-12700: seed word must be a single word

1 Answers  


RMAN-06702: could not initialize for input file: "string"

1 Answers  


ORA-29283: invalid file operation

1 Answers  


ORA-01082: 'row_locking = always' requires the transaction processing option

1 Answers  


NNO-00317: statistic counter reset interval changed to number seconds

1 Answers  


ORA-06953: Not enough virtual memory

1 Answers  


SQL-02101: Inconsistent cursor cache. Unit cursor/global cursor mismatch

1 Answers  


LSX-00215: value "~1S" whose total digits exceeds ~2d

1 Answers  


NNO-00107: line string: ignoring stale checkpoint data

1 Answers  


ORA-14007: missing LESS keyword

1 Answers  


ORA-13285: Geometry coordinate transformation error

1 Answers  


Categories