Import questions

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 24 May 2001 10:01:17 -0700
Message-ID: <77e87b58.0105240901.4078c580@posting.google.com>

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:

How do I do imp such that NO indexes get created? 'imp full=y indexes=n constraints=n'?
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. Received on Thu May 24 2001 - 12:01:17 CDT