Home » Server Options » Replication » Materialized view creation Error (Oracle11gR2 on LINUX)
Materialized view creation Error [message #561279] Fri, 20 July 2012 02:21 Go to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
Dear ALL,

I have a problem in execution of below mentioned Replication script,My destination DB is ORACLE 11gR2 which is running
on Linux PLATFORM and remote DB is ORACLE 10gR2 running on Linux.

furthermore
I have a DBA privilege
I also test my DBLINK which is connected properly

kindly help me in this regards
------------------------------------

CREATE MATERIALIZED VIEW MAHASIL.PERSON_ASSETS_LIABILITIES
TABLESPACE TMSMN
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOCOMPRESS
BUILD IMMEDIATE
REFRESH FAST
START WITH TO_DATE('22-JUL-2012 16:27:50','dd-mon-yyyy hh24:mi:ss')
NEXT sysdate+1/24/60
WITH ROWID
AS
SELECT * FROM PERSON_ASSETS_LIABILITIES@MAHLNK.REGRESS.RDBMS.DEV.US.ORACLE.COM
Error at line 1
ORA-04052: error occurred when looking up remote object SYS.DBMS_SNAPSHOT@MAHLNK.REGRESS.RDBMS.DEV.US.ORACLE.COM
ORA-00604: error occurred at recursive SQL level 2
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from MAHLNK.REGRESS.RDBMS.DEV.US.ORACLE.COM


regards,
Zeeshan Mehboob
DBA
Re: Materialized view creation Error [message #561280 is a reply to message #561279] Fri, 20 July 2012 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58951
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-06544: PL/SQL: internal error, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
 *Cause: A pl/sql internal error occurred.
 *Action:Report as a bug; the first argument is the internal error nuber.

Regards
Michel
Re: Materialized view creation Error [message #561282 is a reply to message #561280] Fri, 20 July 2012 02:30 Go to previous messageGo to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
Dear Michel,

I can't create materialized view with REFRESH FAST option.

regards,
Zeeshan Mehboob
Re: Materialized view creation Error [message #561283 is a reply to message #561282] Fri, 20 July 2012 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 58951
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
*Action:Report as a bug; the first argument is the internal error nuber.

Regards
Michel
Re: Materialized view creation Error [message #561287 is a reply to message #561283] Fri, 20 July 2012 04:16 Go to previous messageGo to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
dear Michel,

when I create Materialized view with REFRESH COMPLETE option on 11gR2 . it is created successfully.
but I can't create materialized view with REFRESH FAST option on the same server.
why?

regards
zeeshan mehboob
Re: Materialized view creation Error [message #561289 is a reply to message #561287] Fri, 20 July 2012 04:30 Go to previous messageGo to next message
Michel Cadot
Messages: 58951
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 20 July 2012 09:36
Quote:
*Action:Report as a bug; the first argument is the internal error nuber.


What don't you understand on the sentence "this is a bug"?

Regards
Michel

[Updated on: Fri, 20 July 2012 04:54]

Report message to a moderator

Re: Materialized view creation Error [message #561291 is a reply to message #561289] Fri, 20 July 2012 04:47 Go to previous messageGo to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
ok Michel i understand, kindly tell me the solution what can I do to resolve this issue.
any necessary steps which i can perform?

regards,
zeeshan
Re: Materialized view creation Error [message #561292 is a reply to message #561291] Fri, 20 July 2012 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 58951
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to go to MOS and search if a workaround or a patch exists.

Regards
Michel
Re: Materialized view creation Error [message #561299 is a reply to message #561292] Fri, 20 July 2012 05:59 Go to previous message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
thanks Michel for help

Regards,
Zeeshan Mehboob
Previous Topic: Materialized view
Next Topic: summarize link for migraton using golden gate
Goto Forum:
  


Current Time: Mon Sep 01 09:30:58 CDT 2014

Total time taken to generate the page: 0.06198 seconds