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-02084: database name is missing a component

1 Answers  


ORA-24755: OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported

1 Answers  


ORA-31602: parameter string value "string" in function string inconsistent with string

1 Answers  


AMD-00112: PROCEDURE string, invalid mode

1 Answers  


ORA-23395: object "string"."string" of type "string" does not exist or is invalid

1 Answers  


ORA-02451: duplicate HASHKEYS specification

1 Answers  


QSM-01584: equivalence, string, has anchor, string, not found in query

1 Answers  


TNS-00269: OFF

1 Answers  


ORA-02803: Retrieval of current time failed

1 Answers  


ORA-13863: Statistics aggregation for service(module/action) string is not enabled

1 Answers  


PCC-00014: Undeclared SQL Identifier "string" at line number in file string

1 Answers  


PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 Answers  


Categories