Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-32339: cannot alter materialized view with the PMOP



ORA-32339: cannot alter materialized view with the PMOP..

Answer / guest

Cause: the materialized view is not allowed to have
destructive PMOPS such as DROP, TRUNCATE and EXCHANGE
(sub)partition. The UGA flag of i_am_a_refresh should be set
first.

Action: execute set_i_am_a_refresh first before alter
materialized view with the PMOP.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06537: CHANGE ... KEEP not supported for BACKUP

1 Answers  


ORA-25012: PARENT and NEW values cannot be identical

1 Answers  


LRM-00112: multiple values not allowed for parameter 'string'

1 Answers  


ORA-02164: DATAFILE clause specified more than once

1 Answers  


RMAN-06493: only UNTIL TIME clause is allowed when performing a restore from autobackup, found: string

1 Answers  


ORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.

1 Answers  


NNO-00304: listen address string length string exceeds maximum of string

1 Answers  


ORA-23442: object already exists for the refresh group template

1 Answers  


AUD-00803: internal error while processing WHERE clause

1 Answers  


ORA-13619: The procedure argument string is greater than the maximum allowable length of string characters.

1 Answers  


ORA-32400: cannot use object id columns from materialized view log on "string"."string"

1 Answers  


RMAN-03023: executing command: string

1 Answers  


Categories