We in the test system is used to derive the DMP file and imported into the production system database, but the use of imp import, imp - 00015, the existing object error, if you use the ignore=y parameters, can lead to import the data table is not complete, there are some business table does not create success,
You have a solution, thanks.

CodePudding user response:

If you use the ignore=y parameters, can lead to import data sheet is not complete


Data sheet is not complete, all has nothing to do with ignore=y, it was built to ignore list error,

You can refer to this:
http://132.232.124.166/post/oracle_segment_created.html

CodePudding user response:

Table structure identical to ignore built table error and is not the same need to resolve the conflict by hand, or just delete the target table to import again, such data can be lost, however, must be careful

CodePudding user response:

Also, met production export import in the test environment, behavior really haven't seen in the opposite direction, terrible
This kind of change it is better to manual processing is more appropriate