Re: imp questions

From: A.Liggins <A.Liggins_at_hotmail.com>
Date: Sat, 8 Sep 2001 12:19:52 +0100
Message-ID: <9ncv0c$e74$1@neptunium.btinternet.com>

You can specify not to import the indexes as a first step (add INDEXES=N). Once the tables are in generate the SQL to build the indexes by doing another pretend import but INDEXFILE=indexes.sql.

You can then edit and run indexes.sql

Alternatively you can rebuild the indexes to another tablespace with ALTER INDEX afterwards (space permitting).

Liggs

"Antony Mak" <cheong_at_broadway-ps.com> wrote in message news:3b95cff6_at_newsgate.imsbiz.com...
> Hi all,
>
> I always have to setup a testing environment by import (drop some tables
and
> import it back). Can anyone tell me can I change some indexes' tablespace
> during import? and What about the functions, procedures, package, synonym
> with the dropped and re-imported table?
>
> Thanks in advance
>
> Antony.
> --
> antony_at_broadway-ps.com
>
>
Received on Sat Sep 08 2001 - 06:19:52 CDT