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

SQL*Loader-00259: Could not escalate DDL share lock to exclusive on table string

1 Answers

ORA-14037: partition bound of partition "string" is too high

1 Answers

ORA-12324: cannot use the ROM: link type on a private database link

1 Answers

ORA-00601: cleanup lock conflict

1 Answers

ORA-12497: maximum combined categories exceeds string

1 Answers

DRG-11812: Moved Permanently

1 Answers

ORA-29871: invalid alter option for a domain index

1 Answers

NNF-01008: XDS attribute syntax string incorrect for Oracle Names syntax string

1 Answers

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

1 Answers

ORA-19575: expected string blocks in file string, found string

1 Answers

DRG-11823: Not Found

1 Answers

RMAN-08591: WARNING: invalid archivelog deletion policy

1 Answers

For more Oracle Errors Interview Questions Click Here