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
3571 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

ORA-24433: This statement has already been prepared using OCIStmtPrepare2.

1 Answers

RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers

UDI-00007: attempt to free unallocated memory

1 Answers

ORA-01639: instance string has no thread assigned to it

1 Answers

ORA-00116: SERVICE_NAMES name is too long

1 Answers

TNS-00525: Insufficient privilege for operation

1 Answers

ORA-32129: cannot get information about this column

1 Answers

ORA-25003: cannot change NEW values for this column type in trigger

1 Answers

ORA-25288: AQ HTTP propagation encountered error, status-code number, string

1 Answers

PLS-01416: Use of <id> (<value>...) here

1 Answers

QSM-01113: HAVING clause of mv, string, is more restrictive than query

1 Answers

ORA-06777: TLI Driver: error reading parms

1 Answers

For more Oracle Errors Interview Questions Click Here