Bug 5527129 : UDE-00019 RETURNED WHEN ATTEMPTING TO EXPORT A LONG LIST OF TABLES VIA EXPDP
To Bottom






 
Bug Attributes
 
Type B - Defect Fixed in Product Version
Severity 2 - Severe Loss of Service Product Version 10.2.0.1
Status 92 - Closed, Not a Bug Platform 23 - Oracle Solaris on SPARC (64-bit)
Created 13-Sep-2006 Platform Version
Updated 08-Feb-2007 Base Bug N/A
Database Version 10.2.0.1 Affects Platforms Generic
Product Source Oracle


 
Related Products
 
Line Oracle Database Products Family Oracle Database
Area Oracle Database Product 5 - Oracle Database - Enterprise Edition


Hdr: 5527129 10.2.0.1 RDBMS 10.2.0.1 UNKNOWN PRODID-5 PORTID-23
Abstract: UDE-00019 RETURNED WHEN ATTEMPTING TO EXPORT A LONG LIST OF TABLES VIA EXPDP
 
*** 09/12/06 01:42 pm ***
TAR:
----
5762960.993
 
PROBLEM:
--------
When performing a Data Pump export operation with a long TABLE=(...) list a 
UDE-00019 error is raised. The same table list is processed without problem 
when using the classic export utility instead of the Data Pump export utility.
 
DIAGNOSTIC ANALYSIS:
--------------------
The symptom of a long list of values causing problems for expdp matches that 
of bug 4053129. However, that bug is flagged as fixed in 10.2.0.1 and the 
customer is currently using 10.2.0.1 RDBMS software.
 
WORKAROUND:
-----------
Use the Data Pump keyword:
 
INCLUDE=TABLE:"IN(select name from schema.table_name)"
 
RELATED BUGS:
-------------
4053129
 
REPRODUCIBILITY:
----------------
At customer's site.
 
TEST CASE:
----------
 
STACK TRACE:
------------
N/A
 
SUPPORTING INFORMATION:
-----------------------
Will upload the parameter file that is being used by the customer.
 
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
 
DIAL-IN INFORMATION:
--------------------
 
IMPACT DATE:
------------
 
*** 09/12/06 01:47 pm ***
*** 09/12/06 01:48 pm *** (CHG: Sta->16)
*** 09/12/06 01:49 pm ***
Error reported by the customer:
 
UDE-00019: 'string' parameter list is too long. 
 
Cause: Requested parameter list exceeds 4000 character maximum.
 
Action: Reduce the specified number of parameter values and rerun.