Home » RDBMS Server » Server Utilities » Recover Partitioned Table DP export into unpartitioned table (10g, Windows)
Recover Partitioned Table DP export into unpartitioned table [message #448499] Tue, 23 March 2010 15:17
Messages: 1
Registered: March 2010
Junior Member
I've been given a Datapump export containing several partitioned tables.
I only have access to Oracle Express, which does not support partitioned tables.

Running a straight import I get:
ORA-39083: Object type TABLE failed to create with error:
ORA-00439: feature not enabled: Partitioning
Failing sql is:
CREATE TABLE <...truncated table definition...>

If I create the table, then run an import with CONTENT=data_only I get:
ORA-31693: Table data object "abc"."tableX":"YYY"."ZZZ" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-02373: Error parsing insert statement for table "abc"."tableX".
ORA-00904: "COLZ": invalid identifier

So, two questions,
1. can you recover the data from a partitioned table datapump export to an unpartitioned table?
2. can you somehow extract the table definition from a datapump extract?
Many thanks,

Previous Topic: SQL Loader & control file problem
Next Topic: How to execute the SQLLDR, where Data File Reside in another Server
Goto Forum:

Current Time: Sat Jul 31 07:03:07 CDT 2021