imp tables only with object column inside

From: C Chang <cschang_at_maxinter.net>
Date: Sun, 02 Feb 2003 22:26:00 -0500
Message-ID: <3E3DE148.5398@maxinter.net>

I have a 8.1.6 on NT 4 with 1 CPU and 6 HDs ( 16 G each), 1G ram I use following script under the prompt and got error as in fedlogdataSupplier.log
imp user/pw file=i:\fedlog_dump\Fedlog.dmp buffer=10000000 fromuser=fedlog
touser=fedlog tables=(fl_supplier) rows=y indexes=n commit=y log=i:\fedlog_dump\fedlogdataSupplier.log I increase the sort_area_size = 10M ( original 1 M) below is the contents of the fedlogdataSupplier.log Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production

Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing FEDLOG's objects into FEDLOG IMP-00015: following statement failed because the object already exists:
"CREATE TYPE "SUPPLIER_T" TIMESTAMP '2002-05-28:08:28:05' OID
'D1F2CF43516A4"
"7ECB3C4FF1EA8037A61' AS OBJECT"
"("
" cage_code VARCHAR2(5),"
" cage_status VARCHAR2(1),"
" office_addr_T addr_T,"

" primary_business VARCHAR2(1)"
");"

IMP-00015: following statement failed because the object already exists:
"CREATE TYPE "ADDR_T" TIMESTAMP '2002-05-28:08:28:05' OID
'50BB7A3C1385426A8"
"1AECD89AA9324B8' AS OBJECT"
"("
" address_1 VARCHAR2(80),"

  "   city         VARCHAR2(40),"


 "   state        VARCHAR2(2),"

 "   zip          VARCHAR2(10),"

" country_code VARCHAR2(36)"
")"

IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "FL_SUPPLIER" OF "SUPPLIER_T" OID
'0F54BF8791F642C7AB1C5B21AEC"
"A731F' ( PRIMARY KEY ("CAGE_CODE")) OBJECT ID PRIMARY KEY PCTFREE 10
PCTUS"
"ED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 1048576)
TABLESPACE ""
"IPVSVR_VD2FL""

Import terminated successfully with warnings.

I have tried both dropping all the objects above and associated tables or creating the objects and tables before I imp, either generated the same error log.
Because I did not use the direct=y during the exp of the whole fedlog.dmp, Does that mean I can not use such imp? Received on Sun Feb 02 2003 - 21:26:00 CST