DATAPUMP_EXP_FULL_DATABASE

How to Resolve ORA-39109: Unprivileged users may not operate upon other users' schemas

by Ed Chen
February 1, 2023May 23, 2023

ORA-39109 Saw error ORA-39109 when we tried to export someone's data from the database. C:\Users\Administrator>expdp ERPAPP@APPDB1 schemas=FINAPP dumpfile=FINAPP-export.dmp logfile=FINAPP-export.log ... ORA-31631: privileges are required ORA-39109:… Read More »

DATAPUMP_IMP_FULL_DATABASE, How and Why

by Ed Chen
November 22, 2022April 26, 2023

DATAPUMP_IMP_FULL_DATABASE DATAPUMP_IMP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database imports… Read More »

DATAPUMP_EXP_FULL_DATABASE, How and Why

by Ed Chen
November 21, 2022April 26, 2023

DATAPUMP_EXP_FULL_DATABASE DATAPUMP_EXP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database exports… Read More »

JavaScript is not enabled. Please enable it and reload the page.