ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Import successful but no objects are imported
Article ID: 186319
CA Automic Applications Manager (AM)
When using the Import feature (IMPEXP Job) to Import objects, the Job is successful and finishes in a FINISHED status. The output file, however, shows that no objects are imported. An example shown below:
This is likely an issue with the sqlldr command which should exist in the $ORACLE_HOME/bin directory.
Release : 9.1
Component : APPLICATIONS MANAGER
Review the $ORACLE_HOME/bin directory to see if sqlldr exists. This particular behavior can be seen if sqlldr does exist BUT is corrupted and/or is a 0 byte file. To resolve this issue, fix sqlldr by either reinstalling Oracle or replacing the 0 byte sqlldr with the correct sqlldr executable.