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

ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

1 Answers  


ORA-38453: ExpFilter index should be created in the same schema as the base table.

1 Answers  


ORA-30186: '' must be followed by four hexdecimal characters or another ''

1 Answers  


NZE-29031: SSL handshake is required.

1 Answers  


RMAN-08122: keep attributes for the backup are changed

1 Answers  


ORA-23314: database is not a materialized view site for "string"."string"

1 Answers  


ORA-14131: enabled UNIQUE constraint exists on one of the tables

1 Answers  


RMAN-10001: error parsing recovery catalog connect string "string"

1 Answers  


DRG-11503: insert statement overflows maximum statement size

1 Answers  


ORA-12631: Username retrieval failed

2 Answers  


ORA-06564: object string does not exist

1 Answers  


ORA-14450: attempt to access a transactional temp table already in use

1 Answers  


Categories