This is with the Import behavior changes in Oracle 12cR2. Please refer to the Oracle corporation manual for more details.
Starting with Oracle Database 12 c Release 2 (12.2), the import utility (imp) SYS no longer imports objects as users for security reasons . If the dump file SYS contains objects that need to be recreated as a user , the imp utility SYSTEM tries to recreate them as a user instead . If the user SYSTEM can not re-create the object, after the import is completed, the user himself / herself has to recreate the object manually.
If the import job is executed by the user with the DBA role and some objects SYSTEM can not be recreated by the user , the following warning message is written to the log file:
IMP-00403:
Warning: This import generated a separate SQL file "logfilename_sys" which contains DDL that failed due to a privilege issue.
The generated SQL file SYSTEM contains the failed DDL of the object that could not be recreated by the user . To recreate these objects, you must manually run the failed DDL after the import is done.
In the SQL file, the name automatically added with '_sys.sql' added to the file name specified by the LOG parameter. For example, if the log file name is JulyImport, the SQL file name is JulyImport_sys.sql.
If no log file is specified, the default name of the SQL file is import_sys.sql.
Note: SQL files are not generated by all import jobs, they are generated only by jobs executed as user DBA.
