| ORA-06502: PL/SQL: numeric or value error in EXPDP [message #407797] |
Thu, 11 June 2009 12:05  |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
Experts,
i am getting following error while taking export of partition table based on query. here is my parameter file and corresponding error message.
my requirement is to test export and import using data pump. for this i am trying to export small number of records by restricting rows using query. export operation is failing in the middle. could you please help me to identify the problem.
DUMPFILE=RAWTXN_200808_exp.dmp
DIRECTORY=DPDUMP
LOGFILE=RAWTXN_200808_exp.log
TABLES=CDSVZW.RAWTXN:RAWTXN_200808
QUERY=CDSVZW.RAWTXN:RAWTXN_200808:"WHERE ROWNUM<100"
JOB_NAME=export_rawtxn_200808_job
EXCLUDE=TRIGGER,INDEX,STATISTICS
PARALLEL=2
Starting "SYSTEM"."EXPORT_RAWTXN_200808_JOB": system/********@BMVZWSTG parfile=export_rawtxn_200808.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.98 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/COMMENT
ORA-31693: Table data object "CDSVZW"."RAWTXN":"RAWTXN_200808" 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
Master table "SYSTEM"."EXPORT_RAWTXN_200808_JOB" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.EXPORT_RAWTXN_200808_JOB is:
/opt/mis2/oracle/admin/BMVZWSTG/dpdump/RAWTXN_200808_exp.dmp
Job "SYSTEM"."EXPORT_RAWTXN_200808_JOB" completed with 1 error(s) at 16:41:47
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
