Home » RDBMS Server » Server Utilities » ORA-06502: PL/SQL: numeric or value error in EXPDP
ORA-06502: PL/SQL: numeric or value error in EXPDP [message #407797] Thu, 11 June 2009 12:05 Go to next message
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
Re: ORA-06502: PL/SQL: numeric or value error in EXPDP [message #407798 is a reply to message #407797] Thu, 11 June 2009 12:09 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


What'your database version (4 digit)

Thanks
Re: ORA-06502: PL/SQL: numeric or value error in EXPDP [message #407800 is a reply to message #407798] Thu, 11 June 2009 12:15 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
SQL*Plus: Release 10.2.0.3.0 - Production
OS is solaris 10
Re: ORA-06502: PL/SQL: numeric or value error in EXPDP [message #407804 is a reply to message #407800] Thu, 11 June 2009 12:29 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Check Metalink Doc ID: 783303.1

Babu
Re: ORA-06502: PL/SQL: numeric or value error in EXPDP [message #407830 is a reply to message #407804] Thu, 11 June 2009 16:29 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Thanks for reply,

i have one question. did you find any thing wrong in my parameter file?

export is failing in the middle. i am not sure why it is
Re: ORA-06502: PL/SQL: numeric or value error in EXPDP [message #407832 is a reply to message #407797] Thu, 11 June 2009 16:52 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>did you find any thing wrong in my parameter file?
It something was seriously wrong with the parameter file, the export would not have started.

Submit a Service Request so Oracle can determine if it is a bug or not.
Previous Topic: SQL LOADER
Next Topic: How i can prevent backup for specific IP Address
Goto Forum:
  


Current Time: Thu Mar 28 08:42:14 CDT 2024