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-30038: Cannot perform parallel insert on non-partitioned object

1 Answers  


ORA-06807: TLI Driver: could not open ethernet device driver file

1 Answers  


ORA-29390: some resource plans are not part of any top-plan

1 Answers  


ORA-01227: log string is inconsistent with other logs

1 Answers  


how to resolve the sqlcode -501 erroe in db2?

2 Answers   Syntel,


ORA-02735: osnfpm: cannot create shared memory segment

1 Answers  


ORA-28001: the password has expired

1 Answers  


ORA-31094: incompatible SQL type "string" for attribute or element "string"

1 Answers  


ORA-09344: spsig: error signalling thread

1 Answers  


ORA-13145: failed to generate range list

1 Answers  


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

1 Answers  


ORA-13774: insufficient privileges to select data from the workload repository

1 Answers  


Categories