Home > database >  Oracle11G library all export and import
Oracle11G library all export and import

Time:09-20

Beijing introduced Oracle11G two libraries of version with exp (imp) export and import
System users to export plus full=y, to resume and ignore on another machine=y full=y
In another server recovery, prompt an error, but I query a user number in the table below and production have the same number of table on the server
I am an Oracle white can't white net tube, how can I cancel this mistakes? See other BBS said the standby database the deleted, I how to operate, not
Big man, teach me step by step, not ah, [expression] [expression] [expression]

.. is import table "MVIEW $_ADV_PARTITION" imported the row 0
.. is import table "REPCAT $_AUDIT_ATTRIBUTE
"IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (SYSTEM. REPCAT $_AUDIT_ATTRIBUTE_PK)
Column 1 TIMESTAMP
Columns 2, 3,
Column 3
Column 4 SYSDATE
IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (SYSTEM. REPCAT $_AUDIT_ATTRIBUTE_PK)
Column 1 GLOBAL NAME
Column 2 2
Column 3 128
Column 4 DBMS_REPUTIL. GLOBAL_NAME imported the row 0
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_AUDIT_ATTRIBUTE "ADD CONSTRAINT REPCAT $_AUDIT_ATTRIBU
"TE_C1" CHECK ((data_type_id in (2, 4, 5, 6, 7) and "
"Data_length is not null)"
"Or (data_type_id not in (2, 4, 5, 6, 7) and"
"Data_length is null)
"") the ENABLE NOVALIDATE
"IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
.. is import table "REPCAT $_AUDIT_COLUMN" imported the row 0
.. is import table "REPCAT $_COLUMN_GROUP" imported the row 0
.. is import table "REPCAT $_CONFLICT" imported the row 0
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_CONFLICT "ADD CONSTRAINT REPCAT $_CONFLICT_C1 CHECK ("
"Conflict_type_id in (1, 2, 3)) ENABLE NOVALIDATE"
IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
.. is import table "REPCAT $_DDL" imported the row 0
.. is import table "REPCAT $_EXCEPTIONS" imported the row 0
.. is import table "REPCAT $_EXTENSION" imported the row 0
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_EXTENSION "ADD CONSTRAINT" REPCAT $_EXTENSION_CODE "CHE"
"The CK (extension_code (0)) IN the ENABLE NOVALIDATE"
IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_EXTENSION "ADD CONSTRAINT REPCAT $_EXTENSION_EXPORTREQ
"" CHECK (export_required IN (' Y ', 'N')) ENABLE NOVALIDATE
"IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_EXTENSION "ADD CONSTRAINT" REPCAT $_EXTENSION_STATUS "C"
"HECK (extension_status IN (0, 1, 2, 3, 4)) ENABLE NOVALIDATE"
IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_EXTENSION "ADD CONSTRAINT REPCAT $_EXTENSION_PUSH_TO_M
"DEF" CHECK (push_to_mdef IN (' Y ', 'N')) ENABLE NOVALIDATE
"IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_EXTENSION "ADD CONSTRAINT REPCAT $_EXTENSION_PUSH_TO_N
"EW" CHECK (push_to_new IN (' Y ', 'N')) ENABLE NOVALIDATE
"IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
.. is import table "REPCAT $_FLAVORS" imported the row 0
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_FLAVORS "ADD CONSTRAINT REPCAT $_FLAVORS_C2 CHECK (pu"
Blished is NULL or "(published in (' Y ', 'N', 'O'))) ENABLE NOVALIDATE"
IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
.. is import table "REPCAT $_FLAVOR_OBJECTS" imported the row 0
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_FLAVOR_OBJECTS "ADD CONSTRAINT REPCAT $_FLAVOR_OBJECTS
"_VERSION" CHECK (version# & gt;=0 AND version# & lt; 65536) ENABLE NOVALIDATE
"IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
.. is import table "REPCAT $_GENERATED" imported the row 0
IMP - 00017:2264 due to ORACLE error, the following statement failure:
"ALTER TABLE" REPCAT $_GENERATED "ADD CONSTRAINT" REPCAT $_GENERATED_OBJ "CHEC
"(" reason "K IN (0, 1, 2, 3, 4, 5, 6, 7, 9, 10)) ENABLE NOVALIDATE"
IMP - 00003: ORACLE error 2264
ORA - 02264: the name has been occupied by the existing constraints
.. is import table "REPCAT $_GROUPED_COLUMN" imported the row 0
.. is import table "REPCAT $_INSTANTIATION_DDL" imported the row 0
.. is import table "REPCAT $_KEY_COLUMNS" imported the row 0
.. is import table "REPCAT $_OBJECT_PARMS" imported the row 0
.. is import table "REPCAT $_OBJECT_TYPES
"IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (SYSTEM. REPCAT $_OBJECT_TYPE_PK)
Column 1-1017
Column 2 GENERATED DDL
Column 3 02
Column 4
IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (SYSTEM. REPCAT $_OBJECT_TYPE_PK)
Column 1-1016
Column 2 DUMMY MATERIALIZED VIEW
Column 3 02
Column 4
IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (SYSTEM. REPCAT $_OBJECT_TYPE_PK)
Column 1-1015
Column 2 UPDATABLE MATERIALIZED VIEW LOG
Column 3 02
Column 4
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related