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
4684 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-28233: double encryption not supported

1 Answers

ORA-10917: TABLESPACE GROUP cannot be specified

1 Answers

ORA-30486: invalid window aggregation group in the window specification

1 Answers

ORA-31044: Top-level prefix length string exceeds maximum string

1 Answers

ORA-31612: Allocation of process descriptor failed.

1 Answers

ORA-24158: invalid table alias

1 Answers

DRG-50949: too many SQEs

1 Answers

KUP-04011: file system is full

1 Answers

ORA-02001: user SYS is not permitted to create indexes with freelist groups

1 Answers

ORA-24183: invalid transformation

1 Answers

ORA-06112: NETTCP: invalid buffer size

1 Answers

ORA-30438: unable to access named pipe 'string'

1 Answers

For more Oracle Errors Interview Questions Click Here