Dear Oracle Guru,
Mau tanya neh.., aku punya server 9i di linux, mau upgrade ke 10g R2
linux juga
prosedurnya gmana ya kalo mau upgrade dari 9i ke 10g?
Coba googling katanya kita export-import datanya pake versi yang 10g-nya,
benarkah demikian?
Tapi pas aku coba timbul masalah seperti dibawah ini:
C:\>exp jr_user/[EMAIL PROTECTED] file=jr20070906.dmp
Export: Release 10.2.0.1.0 - Production on Thu Sep 6 09:03:29 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 41:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully
Kemudian ada yang menyarankan pake expdp (katanya di 10g pake ini ya..?
sorry kgak pake 10g), tapi masalah juga tuh... knapa ya..:
C:\>expdp jr_user/[EMAIL PROTECTED] dumpfile=jr20070906.dmp
Export: Release 10.2.0.1.0 - Production on Thursday, 06 September,
2007 9:15:33
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
UDE-00008: operation generated ORACLE error 6550
ORA-06550: line 1, column 52:
PLS-00201: identifier 'SYS.DBMS_DATAPUMP' must be declared
ORA-06550: line 1, column 52:
PL/SQL: Statement ignored
Ada yang punya solusi, please... :-)
Makasih sebelumnya...
Wassalam,
YUNAN F
[Non-text portions of this message have been removed]
