HI

¡¡¡¡I want to import some tables from mstr.dmp file ,but one of the table failed :

SQL> host imp mstr_metadata/password file= mstr.dmp tables=DSSMDLNKPROP buffer=1000000 IGNORE=y log=mst.log

Import: Release 9.2.0.1.0 - Production on Thu Mar 6 10:13:25 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V08.01.06 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
. importing MSTR_METADATA's objects into MSTR_METADATA
. . importing table "DSSMDLNKPROP"
IMP-00058: ORACLE error 1461 encountered
ORA-01461: can bind a LONG value only for insert into a LONG column
IMP-00028: partial import of previous table rolled back: 12 rows rolled back
Import terminated successfully with warnings.



¡¡
smart

___________________________________________________


¡¡¡¡¡¡¡¡¡¡¡¡


¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ¡¡
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡

Oracle LazyDBA home page