Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

import/export of partitioned table giving trouble.

701667Feb 17 2010 — edited Feb 17 2010

I am trying to export a partitioned table with specifying query clause in the export script. This table is partitioned with range+hash partitions.

I am always getting the same following error during the export of any partitioned table but if I did the same thing with non-partitioned table only for testing purpose it worked fine without any error.

ORA-31693: Table data object "SCHEMANAME"."AUDITING":"A2007"."SYS_SUBP21" failed to load/unload and is being skipped due to error:
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLSetTextVar in routine kuxslSetParam:
LPX-314: an internal failure occurred

This is the export script = expdp schemaName/password directory=dump dumpfile=auditing_20100217.dmp tables=auditing QUERY=AUDITING:\"where \"timestamp\" \> \'01-MAR-2009 12:00:00.000000\' OR \"timestamp\" \< \'01-FEB-2009 12:00:00.000000\'\"

Please help.
Arshad.