ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized

ORA-26577: PRESERVE TABLE can not be used when dropping old
style materialized view string.string

Question Posted / guest

1 Answers
3378 Views
I also Faced
E-Mail Answers

ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized view string.string..

Answer / guest

Cause: The materialized view consists of a view and a
container table.

Action: Drop the materialized view without PRESERVE TABLE
option.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00852: failed to get LDAP entry: error = number

1 Answers

ORA-24195: attemp to retrieve the name list of a map message with size exceeding 1024

1 Answers

ORA-16528: unable to allocate PGA heap

1 Answers

ORA-16002: database already open for read-write access by another instance

1 Answers

ORA-01690: sort area size too small

1 Answers

ORA-25465: variable name not specified

1 Answers

TNS-01302: nr err code: number

1 Answers

RMAN-10032: unhandled exception during execution of job step number: string

1 Answers

ORA-24126: invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure

1 Answers

ORA-16034: FROM parameter is incompatible with MANAGED recovery

1 Answers

ORA-07339: spcre: maximum number of semaphore sets exceeded.

1 Answers

RMAN-08517: backup piece handle=string recid=string stamp=string

1 Answers

For more Oracle Errors Interview Questions Click Here