Permission Problems With Export In EM Cloud Control 12c
(Doc ID 1953533.1)
Last updated on FEBRUARY 18, 2022
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.3.0 and laterInformation in this document applies to any platform.
Goal
Get error for an user to during export schema.
"Error message: "Export Submit Failed" User does not have privileges for this operation"
when perform the following:
Export to Export files ... -> use user with full export and full import role -> select "schemas" -> add schema -> configure logfile -> confiugre export directory and file
show PL/SQL:
declare
h1 NUMBER;
begin
h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA', job_name => '<JOB_NAME>', version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => '<DUMPFILE>', directory => '<DIRECTORY>', filetype => SYS.DBMS_DATAPUMP.KU$FILE_TYPE_DUMP_FILE);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''<SCHEMA>'')');
dbms_datapump.add_file(handle => h1, filename => '<LOGFILE>', directory => '<DIRECTORY>', filetype => SYS.DBMS_DATAPUMP.KU$FILE_TYPE_LOG_FILE);
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
dbms_datapump.set_parameter(handle => h1, name => 'ESTIMATE', value => 'BLOCKS');
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.detach(handle => h1);
end;
/
Export Submit Failed
Solution
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
Goal |
Solution |
References |