Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news1.rdc1.sdca.home.com.POSTED!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: Import Help!
From: Ban Spam <ban-spam@operamail.com>
References: <N85x7.198$lZ6.26737851@newssvr15.news.prodigy.com>
Organization: Black Hole, Inc.
Message-ID: <Xns9136B22823D6FSunnySD@24.0.3.73>
User-Agent: Xnews/4.06.22
Lines: 22
Date: Thu, 11 Oct 2001 00:30:49 GMT
NNTP-Posting-Host: 24.16.103.228
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc1.sdca.home.com 1002760249 24.16.103.228 (Wed, 10 Oct 2001 17:30:49 PDT)
NNTP-Posting-Date: Wed, 10 Oct 2001 17:30:49 PDT
Xref: easynews comp.databases.oracle.server:120882
X-Received-Date: Wed, 10 Oct 2001 18:06:07 MST (news.easynews.com)

"Steve" <schen@prodigy.net> wrote in
news:N85x7.198$lZ6.26737851@newssvr15.news.prodigy.com: 

> Hi,
> 
> Is there anyway to have database data and index imported to different
> tablespaces at the same time?     Currently I am importing data only
> one time, getting index info into a sql file, changing tablespace name
> then exec this sql as the next time.
> 
> It is grateful if someone share his greate idea.
> 
> Steve
> 
> 
> 
> 
> 

Pre-create both the table & index prior to the import
such that they reside where you want them to reside;
then use IGNORE=Y on the import command line.