Re: imp tables only with object column inside

From: C Chang <cschang_at_maxinter.net>
Date: Mon, 03 Feb 2003 22:58:21 -0500
Message-ID: <3E3F3A5C.37ED@maxinter.net>

Frank wrote:
>
> 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.
Do you mean that I have to build the very basic ( most inner ) object first, then import its data, then build next level, import that.. and so on ? Because I have done following based on above structure, I created

1. Add_t type and  then
2. supplier_T and 
3. the fl_supplier table

4 import tables=(fl_supplier)
However, it still produced the same error.

I do not know how to import the data just for the type object ( ex. the Add_T). Can you give me an example? Appreciate.
> If more than a few types/tables, it would probably be more
> efficient to rerun the export. <-- I did not folllow the meaning
>
> Frank

C chang Received on Mon Feb 03 2003 - 21:58:21 CST