Exp/ Imp [message #171068] |
Mon, 08 May 2006 04:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
patcharat
Messages: 1 Registered: May 2006
|
Junior Member |
|
|
I have two Server A and B . I need move data from A to B
Connected to: Oracle9i Enterprise Edition Release 9.0.1.3.1 - Production
With the Partitioning option
JServer Release 9.0.1.3.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in TH8TISASCII character set and UTF8 NCHAR character set
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing HRMS's objects into HRMS
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'HRMS', export_db_name="
">'HRM.WORLD', inst_scn=>'387481332');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00015: following statement failed because the object
already exists:
"CREATE LIBRARY "UTILS_LIB" UNTRUSTED AS 'orawpcom.dll'"
IMP-00017: following statement failed with ORACLE error 922:
# A server
# PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET TH8TISASCII
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0
# B server
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET TH8TISASCII
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET UTF8
NLS_RDBMS_VERSION 9.0.1.3.1
I don't sure about NLS_NCHAR_CHARACTERSET. i try change this value by "alter session NLS_NCHAR_CHARACTERSET = AL16UTF16" i need both server is same. But i can't do it.
Please Help me Why i can't Import data to another server.
[Updated on: Mon, 08 May 2006 04:19] Report message to a moderator
|
|
|
Re: Exp/ Imp [message #171072 is a reply to message #171068] |
Mon, 08 May 2006 04:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
aciolac
Messages: 242 Registered: February 2006
|
Senior Member |
|
|
Give, versions of exporting and importing databases. I think that it is necessary to start from the error
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'HRMS', export_db_name="
">'HRM.WORLD', inst_scn=>'387481332');"
Try to see if this procedure exist in database and you have all necessary privileges on them.
|
|
|
Re: Exp/ Imp [message #174270 is a reply to message #171068] |
Sat, 27 May 2006 02:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kps_sethi
Messages: 2 Registered: May 2006 Location: India
|
Junior Member |
|
|
Hi there,
I also faced similar kind of problems in past and found that this is due to two issues.
1. some packages were not installed, so I run catrep.sql to install them all.
2. Objects that I am importing, already exists, you can keep ignore flag as Y during import.
regards
KPS Sethi
|
|
|
Re: Exp/ Imp [message #175595 is a reply to message #174270] |
Sat, 03 June 2006 03:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
animesh303
Messages: 12 Registered: June 2006
|
Junior Member |
|
|
Hi
Export file created by EXPORT:V09.02.00 via conventional path
This statement specifies that the export was taken by Export Utility of higher version.
Your Database version is 9.0.1.3.1.
So I suggest you use the Export Utility of version 9.0.1.3.1 or lower.
Higher version utility looks for new packages and procedures for execution which are not available in lower version databases.
Hope this works fine.
Thanks and regards
Animesh
|
|
|