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...


QSM-02163: cannot use object id columns from materialized
view log



QSM-02163: cannot use object id columns from materialized view log..

Answer / guest

Cause: The materialized view log either does not have object
id columns logged, or the timestamp associated with the
object id columns is more recent than the last refresh time.

Action: A complete refresh is required before the next fast
refresh. Add object id columns to the materialized view log,
if required.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"

1 Answers  


DRG-12802: invalid type column: string

1 Answers  


ORA-09759: osnsbt: bad message received.

1 Answers  


PLS-00517: Type mismatch between a select list element 'string' and corresponding table column in INSERT statement with a subquery

1 Answers  


RMAN-06114: changed controlfile copy available

1 Answers  


ORA-01299: dictionary string corresponds to a different database incarnation

1 Answers  


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

0 Answers   IBM,


ORA-30131: number of keys being set exceeds allocation

1 Answers  


TNS-00000: Not An Error

1 Answers  


ORA-09753: spwat: invalid process number.

1 Answers  


DRG-11208: ORACLE_HOME is not set

1 Answers  


QSM-00511: invalid fact-tables specified in fact-filter

1 Answers  


Categories