Export:
@ echo.
Color 0 a
@ echo is export database, please wait a moment,,,
Set mydate=% date: date: ~ 0, 4 % % % % date: ~ 5, 2 ~ 8, 2 %
Md D: \ backup programs hsmobile \ production \ dbbak mydate \ % %
Exp hsinfo/888888 @ APP file=D: \ backup programs hsmobile \ production \ \ hsinfo mydate dbbak \ % % % % mydate. DMP log=D: \ backup programs hsmobile \ production \ \ hsinfo_ mydate dbbak \ % % % % mydate. Log full=y
@ echo.
@ echo ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
@ echo ` database export finished! `
@ echo ` `
@ echo ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
@ echo
Pause


Import:
@ echo.
Color 0 a
@ echo is import database, please wait a moment,,,
Set mydate=% date: date: ~ 0, 4 % % % % date: ~ 5, 2 ~ 8, 2 %
Imp hsinfo/888888 @ APP_BAK file=D: \ backup programs hsmobile \ production \ \ hsinfo mydate dbbak \ % % % % mydate. The DMP log=D: \ backup programs hsmobile \ production \ \ hsinfo_imp_ mydate dbbak \ % % % % mydate. Log full=y ignore=y
@ echo.
@ echo ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
@ echo ` the import is complete! `
@ echo ` `
@ echo ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
@ echo
Pause


Import journal: (too much, only post one part)

To connect to: Oracle Database 11 g Enterprise Edition Release 11.2.0.4.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options

Through regular path by EXPORT: V11.02.00 create the EXPORT file
Has been completed ZHS16GBK character sets and AL16UTF16 NCHAR import
in a character setBeing imported into the SYSTEM the SYSTEM objects
. Is imported into ORDDATA objects ORDDATA
. Is imported into OLAPSYS objects OLAPSYS
Being imported into the SYSMAN objects SYSMAN
. Is imported into APEX_030200 objects APEX_030200
. Is imported into HSINFO objects HSINFO
Being imported into the SYSTEM the SYSTEM objects
. Is imported into OLAPSYS objects OLAPSYS
Being imported into the SYSMAN objects SYSMAN
. Is imported into APEX_030200 objects APEX_030200
. Is imported into HSINFO objects HSINFO
IMP - 00061: warning: object type "HSINFO". "ROW_INDEX" already exist in different identifiers
"The CREATE TYPE" ROW_INDEX "TIMESTAMP '2015-12-17:23:13:13' OID '271 a73f4b9dd20"
"40 e055000000000001 'is the object ("
"Vc_index_name varchar2 (50),"
"Vc_uniqueness varchar2 (20),"
"Vc_columns varchar2 (1000))"
IMP - 00061: warning: object type "HSINFO". "TABLE_INDEX" already exist in different identifiers
"The CREATE TYPE" TABLE_INDEX "TIMESTAMP '2015-12-17:23:21:09' OID '271 a73f4b9e7"
"2040 e055000000000001 'as the table of row_index"
Being imported into the SYSTEM the SYSTEM objects
Being imported into the SYS objects SYS
Being imported into the SYSTEM the SYSTEM objects
Being imported into the SYS objects SYS
Being imported into the SYSTEM the SYSTEM objects
. Is imported into OUTLN objects OUTLN
. Is imported into ORDDATA objects ORDDATA
. Is imported into OLAPSYS objects OLAPSYS
. Is imported into MDDATA objects MDDATA
. Is imported into SPATIAL_WFS_ADMIN_USR objects SPATIAL_WFS_ADMIN_USR
. Is imported into SPATIAL_CSW_ADMIN_USR objects SPATIAL_CSW_ADMIN_USR
Being imported into the SYSMAN objects SYSMAN
. Is imported into MGMT_VIEW objects MGMT_VIEW
. Is imported into FLOWS_FILES objects FLOWS_FILES
. Is imported into APEX_PUBLIC_USER objects APEX_PUBLIC_USER
. Is imported into APEX_030200 objects APEX_030200
. Is imported into OWBSYS objects OWBSYS
. Is imported into OWBSYS_AUDIT objects OWBSYS_AUDIT
Being imported into the SCOTT objects SCOTT
. Is imported into HSINFO objects HSINFO
Being imported into the SYSTEM the SYSTEM objects
.. is import table "DEF $_AQCALL" imported the row 0
.. is import table "DEF $_AQERROR" imported the row 0
.. is import table "DEF $_CALLDEST" imported the row 0
.. is import table "DEF $_DEFAULTDEST" imported the row 0
.. is import table "DEF $_DESTINATION
"IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (SYSTEM. DEF $_DESTINATION_PRIMARY)
Column 1 former
Column 2 0
Column 3
Column 4 0
Column 5 F
Column 6
The column 7 0
Column 8 0
The nine
Column 10
Column 11 00
Column 12 F
Column 13 0
Column 3 of 14
Column 15 0
16 column 0
Column 17 0
18 00000000
The column 19 0
List of 20 0
List of 21 0
Column line 22 0 imported the 0
.. is import table "DEF $_ERROR" imported the row 0
.. is import table "DEF $_LOB" imported the row 0
.. is import table "DEF $_ORIGIN" imported the row 0
.. is import table "DEF $_PROPAGATOR" imported the row 0
.. is import table "DEF $_PUSHED_TRANSACTIONS" imported the row 0
.. is import table "MVIEW $_ADV_INDEX" imported the row 0
.. 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)
"nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull