imp system/password file=sys07.dmp fromuser=manpower touser=test tables=c_ymmon grants=n indexes=n
Import: Release 10.2.0.5.0 - Production on Mon Feb 17 10:21:03 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
Export file created by EXPORT:V10.02.01 via direct path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. importing MANPOWER's objects into TEST
. . importing table "C_YMMON" 1966057 rows imported
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the ex¡ä¿¡æ¯)'e:
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'人員生物特å¾è¨˜éŒ„LOG檔(FACE_PERDATA_LOG)'
IMP-00032: S¡è€ƒå‹¤é»žæŒ‡å®šæª”(FACE_WARESEC)'h
IMP-00032: SQL statement exceeded buffer length file:
IMP-00008: unrecognized statement in the export file:
'考勤點與人臉è¨å‚™é—œè¯æª”(FACE_WHERE_DEVICE)'
Import terminated successfully with warnings.
Import: Release 10.2.0.5.0 - Production on Mon Feb 17 10:21:03 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
Export file created by EXPORT:V10.02.01 via direct path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. importing MANPOWER's objects into TEST
. . importing table "C_YMMON" 1966057 rows imported
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the ex¡ä¿¡æ¯)'e:
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'人員生物特å¾è¨˜éŒ„LOG檔(FACE_PERDATA_LOG)'
IMP-00032: S¡è€ƒå‹¤é»žæŒ‡å®šæª”(FACE_WARESEC)'h
IMP-00032: SQL statement exceeded buffer length file:
IMP-00008: unrecognized statement in the export file:
'考勤點與人臉è¨å‚™é—œè¯æª”(FACE_WHERE_DEVICE)'
Import terminated successfully with warnings.
------------------------------------------------------
先确保NLS_LANG设定正确。
imp system/password file=sys07.dmp fromuser=manpower touser=test tables=c_ymmon grants=n indexes=n buffer=1000000