Hello All,
We've been seeing an error when using the old EXP/IMP method of moving database users from an old Oracle 9i site to Oracle 12c SE2. The error has also been observed when we were forced to do the same from a 12c SE2 to a 12c SE2.
The error is:
IMP-00403:
Warning: This import generated a separate SQL file "import_sys" which contains DDL that failed due to a privilege issue.
The file it references is 0 bytes, and all data seems to import OK. Further more - if you do an export of that user's data *from* that new 12c SE2 database - back into the *same* database, you also get that error!
We've recreated the users from scratch, using same scripts, and even exported out the grants/roles of the old user to make sure nothing was missed, but don't see any privilege issues. This error was not previously seen in 11g or 12c SE1, so I'm wondering if something changed with SE2/12.2? Searching online reveals virtually no one else reporting this error code (which always scares me a bit).
We always use Data Pump when possible, and obviously the 12c to 12c issue was just a fluke seen when we were testing the 9i issue, but does anyone have any ideas?
Note: For migrating these old customers, we are doing 9i EXP -> 11g IMP -> 11g EXPDP -> 12c IMPDP
Thank you for your thoughts!