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-12004: REFRESH FAST cannot be used for materialized view
"string"."string"



ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"..

Answer / guest

Cause: The materialized view log does not exist or cannot be
used. PCT refresh is also not enabled on the materialized view

Action: Use just REFRESH, which will reinstantiate the
entire table. If a materialized view log exists and the form
of the materialized view allows the use of a materialized
view log or PCT refresh is possible after a given set of
changes, REFRESH FAST will be available starting the next
time the materialized view is refreshed.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06401: database is already started

1 Answers  


ORA-09764: osnmop: access error on oracle executable

1 Answers  


ORA-15109: conflicting protection attributes specified

1 Answers  


ORA-01596: cannot specify system in string parameter

1 Answers  


RMAN-05008: SET NEWNAME TO NEW not allowed (datafile string)

1 Answers  


ORA-29351: can not transport system, sysaux, or temporary tablespace 'string'

1 Answers  


QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode

1 Answers  


ORA-39307: the operation is illegal without an initial clone

1 Answers  


TNS-01441: Number of filtering rules currently in effect: number

1 Answers  


ORA-13409: null or invalid pyramidLevel parameter

1 Answers  


ORA-00606: Internal error code

1 Answers  


ORA-02455: The number of cluster key column must be 1

1 Answers  


Categories