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
3465 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-04003: sequence parameter string exceeds maximum size allowed (string digits)

1 Answers

LSX-00245: invalid ID "~S"

1 Answers

NNL-00874: Slowest update processing time: string

1 Answers

ORA-13260: layer table string does not exist

1 Answers

ORA-24417: Session pool size has exceeded the maximum limit

1 Answers

RMAN-06198: %-24s string bytes

1 Answers

ORA-12808: cannot set string_INSTANCES greater than number of instances string

1 Answers

ORA-13142: invalid PROXIMITY window definition

1 Answers

ORA-38747: corrupt before image (file# string, block# string)

1 Answers

TNS-00536: Connection entered inappropriate state

1 Answers

ORA-32601: value for retention cannot be provided

1 Answers

LSX-00263: undefined attribute "~S"

1 Answers

For more Oracle Errors Interview Questions Click Here