Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: C Chang <cschang@maxinter.net>
Newsgroups: comp.databases.oracle.misc
Subject: imp tables only with object column inside
Date: Sun, 02 Feb 2003 22:26:00 -0500
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <3E3DE148.5398@maxinter.net>
X-Mailer: Mozilla 3.01Gold (Win95; I)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 53
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:92624
X-Received-Date: Sun, 02 Feb 2003 20:14:26 MST (news.easynews.com)

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?