ORA-01662 tablespace ' string ' is non-empty and cannot be made temporary
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01662 from Oracle 10g ?
Tried to convert a non-empty tablespace to a temporary tablespace
How to deal with ORA-01662 from Oracle 10g ?
To drop all the objects in the tablespace.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01654 unable to extend index string . string by string in tablespace string
- ORA-01655 unable to extend cluster string . string by string in tablespace string
- ORA-01656 max # extents ( string ) reached in cluster string . string
- ORA-01657 invalid SHRINK option value
- ORA-01658 unable to create INITIAL extent for segment in tablespace string
- ORA-01659 unable to allocate MINEXTENTS beyond string in tablespace string
- ORA-01660 tablespace ' string ' is already permanent
- ORA-01661 tablespace ' string ' is already temporary
- ORA-01663 the contents of tablespace ' string ' is constantly changing
- ORA-01664 Transaction which has expanded the Sort Segment has aborted
- ORA-01665 controlfile is not a standby controlfile
- ORA-01666 controlfile is for a standby database
- ORA-01667 cannot add any more tablespaces: limit of string exceeded
- ORA-01668 standby database requires DROP option for offline of data file
- ORA-01669 standby database controlfile not consistent
- ORA-01670 new datafile string needed for standby database recovery