Can we read the export dumps created using expdp using ORACLE_DATAPUMP driver (220.127.116.11)?
1) Export a table using expdp
expdp testuser/testuser DIRECTORY=TEST_DUR tables=TABLE_1 DUMPFILE=test.dmp LOGFILE=test.log
2) Read the dump file created in step-1
CREATE TABLE my_test(
ORGANIZATION EXTERNAL (
DEFAULT DIRECTORY test_dir
)REJECT LIMIT UNLIMITED;
select * from my_test;
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-31619: invalid dump file "/u08/export/test.dmp"
Here's the version info:
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
PL/SQL Release 22.214.171.124.0 - Production
CORE 126.96.36.199.0 Production
TNS for Linux: Version 188.8.131.52.0 - Production
NLSRTL Version 184.108.40.206.0 - Production
Is it possible to read the dumpfile like this????
Appreciate your answer in this regard.
in your original post, you reference "TEST_DUR" and "TEST_DIR" -- seems like you mistyped the name of the directory in one case. I'm not sure if that has anything to do with the error you are getting, but you need to be careful. Also, be sure that you copy and paste what you did, not type what you did.
I did a very similar example and it worked for me without any problem. So check everything carefully one more time -- directory name, file name, how dump file was produced etc. If you don't find an error, then importing that dumpfile and see if the import works.
Anything created by expdp can only be read by impdp (ot the dbms_datapump plsql package). Any external tables created with the datapump driver can only be used by as external tables files. While the 'driver' is essentially the same the header information is different and the two types of file are not interchangeable.
What do you actually want to do in the first place?
correct - from the oracle docs:
When Data Pump uses external tables as the data access mechanism, it uses the
access driver. However, it is important to understand that the files that Data Pump creates when it uses external tables are not
compatible with files created when you manually create an external table using the SQL
CREATE TABLE ... ORGANIZATION EXTERNAL
statement. One of the reasons for this is that a manually created external table unloads only data (no metadata), whereas Data Pump maintains both data and metadata information for all objects involved.