How to import just the data without indexes and constraints in Oracle using 'imp' command

Question

We get *.dmp files from client which has some masked table data including indexes and constraints. I do have those table structures (including indexes and constraints) at my end. I want to import just the data without the indexes and constraints (present in the .dmp file) in Oracle10g using 'imp' command.

I am aware of the 'imp' command. Do help me in letting me know the options available in 'imp' command to import only the data.

I have tried using -- rows=yes indexes=no but this does not help.

Answer 1

You should be able to specify indexes=N and constraints=N.

For more info:

%> imp help=y 

Here is a link with some good info on the options: Oracle imp information