| Materialized view creation Error [message #561279] |
Fri, 20 July 2012 02:21  |
 |
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  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
