OraFAQ Forum: Server Utilities » Impor error columns xmltype and clob

Home » RDBMS Server » Server Utilities » Impor error columns xmltype and clob

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Impor error columns xmltype and clob [message #177503]

Thu, 15 June 2006 02:39

mcamachopastor
Messages: 2
Registered: June 2006
Location: Madrid

Junior Member

Hi we have a export .dmp with the following columns
idd varchar2(12)
version date
text xmltype
text2 clob.
when we try to do and import the import make the table but there is no data on it.
The import error is
IMP-00058 oracle error 942 encountered
ORA-00942 Table or view does not exist.

PD->The import and export is release 9.2.6.0

Thanks in adavance!!!

Import: Release 9.2.0.6.0 - Production on Thu Jun 15 10:46:24 2006

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

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

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by TEXT, not by you

import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)

. importing TEXT's objects into EXPERTIAARES

. . importing table "DOC_XML"

IMP-00058: ORACLE error 942 encountered
ORA-00942: table or view does not exist

Import terminated successfully with warnings.