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

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

Question Posted / guest

1 Answers
4751 Views
I also Faced
E-Mail Answers

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-09932: Close of ORACLE password file failed.

1 Answers

DRG-52210: error while registering value for attribute: string

1 Answers

NNL-00802: Queries received, type ADDRESS: number

1 Answers

ORA-06126: NETTCP: ORASRV unable to open network connection

1 Answers

ORA-16407: Standby database is in the future of the archive log

1 Answers

LPX-00261: invalid URL ~s

1 Answers

ORA-25207: enqueue failed, queue string.string is disabled from enqueueing

1 Answers

PLS-00484: redundant exceptions 'string' and 'string' must appear in same exception handler

1 Answers

TNS-00114: Internal error- Allocation of addresses not performed

1 Answers

ORA-13144: target table string not found

1 Answers

TNS-00311: Connection Manager: Failed to start tracing after rereading parameter data

1 Answers

ORA-13506: operation failed due to invalid snapshot range (string, string)

1 Answers

For more Oracle Errors Interview Questions Click Here