Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: IMPORT - Separating indexes in diff. tablespace

Re: IMPORT - Separating indexes in diff. tablespace

From: Jim W <no_spam_mavp05_at_dial.pipex.com>
Date: 1998/07/09
Message-ID: <6o2s7f$mrq$1@flex.london.pipex.net>#1/1

I'm assuming you mean taking an indexfile from the dump file. Therefore creating a file with every create table and create index in it ?

If you are it's no different if you are using imp73, INDEXFILE=<filename>.

You can then edit that file to strip out your indexes and specify what tablespace you want them in by globalling changing all references to a tablespace.

Hope this is what you're after !

Cheers
Jim. Received on Thu Jul 09 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US