C Chang wrote:
> 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
Re-reading your OP, the error is on the fact the object _exists_.
Tru running with ignore=y
And: do the tables contain data or not? If so - don't worry.
Frank
Received on Tue Feb 04 2003 - 13:25:44 CST