Re: Import Help!

From: Ban Spam <ban-spam_at_operamail.com>
Date: Thu, 11 Oct 2001 00:30:49 GMT
Message-ID: <Xns9136B22823D6FSunnySD@24.0.3.73>

"Steve" <schen_at_prodigy.net> wrote in
news:N85x7.198$lZ6.26737851_at_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. Received on Wed Oct 10 2001 - 19:30:49 CDT