Re: imp tables only with object column inside

C Chang wrote:
> 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?

No, but you will have to create the (nested) types yourself, and rerun the import for those specific tables again. If more than a few types/tables, it would probably be more efficient to rerun the export.

Frank Received on Mon Feb 03 2003 - 14:44:20 CST