ORA-12801: error signaled on server P000, instance 6 of queries parallel
(Doc ID 2420960.1)
Last updated on FEBRUARY 16, 2020
Applies to:
Autonomous Database on Shared Infrastructure - Version N/A to N/AInformation in this document applies to any platform.
Symptoms
Loading Data in the form of compressed file in object storage using the DBMS_CLOUD.COPY_DATA in ADWS instance is failing with below error :
BEGIN
DBMS_CLOUD.COPY_DATA(
table_name => 'beneficio_categoria',
credential_name => 'CRED_XXXXX',
file_uri_list => 'https://uscom-central-1.storage.oraclecloud.com/v1/Storage-ageaadwc/container01/BENEFICIO_CATEGORIA_1.txt.gz',
format => json_object('delimiter' value '|'));
END;
/
This procedure runs successfully, but sometimes is obtained the following error, being this is ramdonly
ERROR en línea 1:
ORA-12801: error signaled on server P000, instance 6 of queries
parallel
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 801
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 782
ORA-29913: error when executing the ODCIEXTTABLEFETCH call
ORA-30653: the rejection limit has been reached
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 757
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 819
ORA-06512: en línea 2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |