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



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-14022: creation of LOCAL partitioned cluster indices is not supported

1 Answers  


ORA-01939: only the ADMIN OPTION can be specified

1 Answers  


RMAN-08550: autobackup search outside recovery area not attempted because DBID was not set

1 Answers  


ORA-02402: PLAN_TABLE not found

1 Answers  


ORA-30051: VERSIONS clause not allowed here

1 Answers  






ORA-10582: The control file is not a backup control file

1 Answers  


PLS-00234: PARAMETER STYLE SQL may not be specified with a PARAMATERS list

1 Answers  


ORA-07265: sppst: semop error, unable to increment semaphore.

1 Answers  


ORA-16716: clearing parameter LOG_ARCHIVE_DEST failed

1 Answers  


PLS-00529: Bad column name string in INSERT statement (must be an identifier)

1 Answers  


PLS-00243: invalid external type specification for SQLNAME

1 Answers  


ORA-24019: identifier for string too long, should not be greater than string characters

1 Answers  


Categories