Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import questions
Vikas Agnihotri wrote:
> Doing a full import from a 'exp full=y'
>
> I pre-created my tablespaces.
>
> Now I want to import everything except the indexes, run the indexfile
> and then edit the indexfile to add (parallel, nologging, compress) and
> create indexes.
>
> I did the following
>
> 'imp full=y indexes=n'
>
> Strangely, this seems to have created some indexes also. Looking
> closer, they seem to be the indexes associated with unique/pk
> constraints.
>
> Questions:
>
> 1. How do I do imp such that NO indexes get created? 'imp full=y
> indexes=n constraints=n'?
>
> 2. If so, then I then do a 'imp full=y indexfile=index.sql', edit
> index.sql and run it to create indexes.
>
> Do I then need to run 'imp full=y indexes=n constraints=y' to create
> all my constraints? Will the PK/unique constraints automatically use
> the existing indexes to enforce the constraints?
>
> Would appreciate help from someone who has done this sort of thing
> before.
>
> Thanks for your help.
Why not just move the PK indexes with an 'ALTER INDEX REBUILD TABLESPACE <indexes>;'
Since this uses the existing index as a source, it should proceed rather
rapidly.
Hiking up the sort_area_size wouldn't hurt either.
hth,
Paul Received on Thu May 24 2001 - 20:55:10 CDT