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-19575: expected string blocks in file string, found string

1 Answers  


ORA-01190: controlfile or data file string is from before the last RESETLOGS

1 Answers  


ORA-30018: Create Rollback Segment failed, USN string is out of range

1 Answers  


KUP-04018: partial record at end of file string

1 Answers  


ORA-04028: cannot generate diana for object stringstringstringstringstring

2 Answers  






NNL-01053: Request processing enabled: string

1 Answers  


ORA-22312: must specify either CASCADE or INVALIDATE option

1 Answers  


ORA-15095: reached maximum ASM file size (string GB)

1 Answers  


ORA-06777: TLI Driver: error reading parms

1 Answers  


ORA-21500: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

1 Answers  


RMAN-06109: changed archive log unavailable

1 Answers  


ORA-28183: proper authentication not provided by proxy

1 Answers  


Categories