Hi
Ignore=y will do the job for your case. Ignore=y switch
will ignore the creation of object when error is encountered
while issuing "Create" command. This switch is used if the
the object being imported already exist in the database.
HTH
pradhan
s wrote in message <379FA013.3DA1E824_at_yahoo.com>...
>We are getting ready to import data from a development machine into a
>production machine. We are running Oracle 8.0.5 on Solaris 2.7.
>The actual tablespace default storage parameters have changed between
>systems, and we of course want to keep the parameters identified
>for the production machine when importing the data.
>
>I believe that the export file does export the storage parameters, so
>what that means, is that we should create the tables with the
>tablespace storage parameters before imporing and then
>import the export file with IGNORE =Y.
>
>Is this correct?
>
>Thanks!
>
Received on Wed Jul 28 1999 - 20:02:45 CDT
