ORA-12083: must use DROP MATERIALIZED VIEW to drop
"string"."string"



ORA-12083: must use DROP MATERIALIZED VIEW to drop "string"."string"..

Answer / guest

Cause: An attempt was made to drop a materialized view using
a command other than DROP MATERIALIZED VIEW.

Action: Use the DROP MATERIALIZED VIEW command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01025: materialized view, string, not found

1 Answers  


ORA-22818: subquery expressions not allowed here

1 Answers  


ORA-06564: object string does not exist

1 Answers  


ORA-12911: permanent tablespace cannot be temporary tablespace

1 Answers  


ORA-02184: resource quotas are not allowed in REVOKE

1 Answers  






PCB-00215: OCCURS TO TIMES clause not allowed for host variable "string"

1 Answers  


ORA-23492: no new sites for extension request "string"

1 Answers  


ORA-16217: prepare to switchover has not completed

1 Answers  


ORA-27086: unable to lock file - already in use

1 Answers  


NNO-00323: overriding next statistic counter dump, dumping in number seconds

1 Answers  


ORA-40208: duplicate or multiple algorithm settings for function string

1 Answers  


ORA-02284: duplicate INCREMENT BY specifications

1 Answers  


Categories