Skip to Main Content

Oracle Database Free

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

expdp from 23.3 fails with error ORA-04036: PGA memory used by the instance or PDB exceeds PGA_AGGREGATE_LIMIT.

Amin AdatiaMay 1 2025

I am trying to get an export of the Tables I have in 3 schemas to import into 23.7. Below is the script and the error messages.
I connect as SYSTEM

#expdp parfile=expdp_shema_parfile.par

DIRECTORY=DATA_PUMP_DIR
#PARALLEL=8

#SCHEMAS=GBMDBA
#LOGFILE=GBMDBA_export_23_3.log
#JOB_NAME=GBMDBA_EXPORT_JOB
#DUMPFILE=GBMDBA_export_23_3.dmp

#SCHEMAS=EFMSI
#LOGFILE=EFMSI_export_23_3.log
#JOB_NAME=EFMSI_EXPORT_JOB
#DUMPFILE=EFMSI_export_23_3.dmp

#ATTACH=HR_EXPORT_JOB
#STOP_JOB=HR_EXPORT_JOB
SCHEMAS=HR
LOGFILE=HR_export_23_3.log
JOB_NAME=HR_EXPORT_JOB
DUMPFILE=HR_export_23_3.dmp

COMPRESSION=METADATA_ONLY
REUSE_DUMPFILES=YES
METRICS=YES
#ACCESS_METHOD=external_table

#ESTIMATE=blocks
EXCLUDE=STATISTICS
#DATA_ACCESS_METHOD=direct_path
#TRANSFORM=LOB_STORAGE:SECUREFILE
#EXCLUDE=LOB_STORAGE_POLICY


#
# ERROR
#Username: hr@FREEPDB1
#Password: 

#Connected to: Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
#ORA-31626: job does not exist
#ORA-31633: unable to create master table "HR.HR_EXPORT_JOB"
#ORA-06512: at "SYS.DBMS_SYS_ERROR", line 140
#ORA-06512: at "SYS.KUPV$FT", line 1146
#ORA-04088: error during execution of trigger 'LBACSYS.LBAC$AFTER_CREATE'
#ORA-06512: at "SYS.KUPV$FT", line 1039
#ORA-00604: Error occurred at recursive SQL level 2. Check subsequent errors.
#ORA-04036: PGA memory used by the instance or PDB exceeds PGA_AGGREGATE_LIMIT.
#ORA-06512: at "LBACSYS.LBAC_EVENTS", line 50
#ORA-06512: at line 2
#ORA-06512: at "SYS.KUPV$FT", line 1029


Comments
Post Details
Added on May 1 2025
0 comments
39 views