Fixing Oracle Database ORA-29913 Error!

Published by Jacob Martin on April 25, 2014

Uses of External Tables are on high demand and it is becoming more popular and as result it’s eradicating the use of SQL loader for loading tables. But, nevertheless you may also face problems while working with external tables. As one of them is mentioned below:

When you try to import schema or job or when you perform “select” operation on external tables, you may get such errors which similar to the followings:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-31693: Table data object “SH”.”SALES_REG1_Q1″ failed to load/unload and is being skipped due to error

ORA-06512: at “SYS.ORACLE_LOADER”, line 19”

ORA-29400: data cartridge error, etc

The most common causes of the ORA-29913 error are either Oracle database fails to open OS file that is required or when you use to open both PARALLEL (>1) and REMAP_SCHEMA at the one time. These files might contain output, input, log, discard or bad files. The main reason behind such scenario can be due to Oracle executable has denied the permission or the file granted the permission or directory itself does not exist for accessing the directory properly.

You can also finds in the error line that Oracle failed to load the table data or write the log files, it may be might be problems with table directory or the .log files in the directory. Oracle versions that can be affected are 11.2.0.1, 11.1.0.7 and 10.2.0.4.

Hence, it is suggestible that users must perform few checks while you try to work with external tables that are mentioned below:

• Make sure whether the directories have granted the required rights or permission for Oracle to carry out read and write to them or not.

• Check the statements that you have used for making directory.

• Execute the special check on ownership and permissions for network directories.

• Make sure that there is no issue related with permission for existing files.

Solutions

However you can fix the issue by following out some suggested tips that are mentioned below:

1 – Create Physical directories to every to all nodes of cluster and make copy of the physical data files to every and all location.

2 – Employ a cluster file system at OS level that is observable from all nodes. Though it is expensive but it is useful and important.

3 – While you represent the space from NAS or SAN, it can be presented as NFS. Take a note that it also requires a separate license from storage supplier.

4 – When you get connected with external tables, make sure that you are connected to precise instance, but remember you will not be able to take benefit of services.

If the error persists again then at such cases you can use third party Oracle file repair tool to fix the issue. With the help of this repair tool you can also fix ORA-00600 error and ORA-01210 error. Furthermore this tool helps you to repair and recovers your corrupted Oracle database file safely and securely.

Steps to fix Oracle Database ORA-29913 Error

Step 1: Search Initial screen of Stellar Phoenix Oracle Recovery with a pop-up window showing options to select or search corrupt Oracle databases in your computer.

Step 2: Click Scan File to initiate the scan process after selecting the oracle database. The recoverable database objects get listed in left-side pane.

Step 3: Click an object to see its preview.

Step 4: : Click Start Repair in the icon bar to start the repair process. A pop-up window is displayed which show the steps needed to perform further. Click next and continue.

Step 5: Give the user name, password and path of the blank database where you want to save the repaired database objects.

Step 6: Repairing and restoring various database objects after establishing a connection with blank oracle database.

Conclusion

So, this is what you can to do fix the problems, but whatever option you select to perform, make sure you do it with carefully and efficiently that results in no further issue with the Oracle Database.

329 Total Views 1 Views Today