| Recover Partitioned Table DP export into unpartitioned table [message #448499] |
Tue, 23 March 2010 15:17 |
Abroad
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,
Tony
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
