Home/ Questions/Q 1414
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-09-29T18:20:31+00:00

How to export Database user from Apex Application Run Time

  • 1
  • 1

Dear,

I have deployed an application from client side which has been working fine. However, i am facing issue regarding database user backup. 

So now i am looking the way to export database user from Apex application.

Thanks. 

oracle apex
Share
Leave an answer

Leave an answer

Browse

3 Answers

  1. You can export the user/schema using the dbms_datapump utility package. Check the below example:

    Also, create a database directory object before running the procedure:

    CREATE OR REPLACE DIRECTORY bkp_dir AS '/usr01/apps/oradata/';

    Then run the following program; it will export the ERP schema. Configure the user/schema name accordingly.

    DECLARE
  l_dp_handle       NUMBER;
BEGIN
  -- Open an schema export job.
  l_dp_handle := DBMS_DATAPUMP.open(
    operation   => 'EXPORT',
    job_mode    => 'SCHEMA',
    remote_link => NULL,
    job_name    => 'ERP_EXPORT',
    version     => 'LATEST');

  DBMS_DATAPUMP.add_file(
    handle    => l_dp_handle,
    filename  => 'ERP.dmp',
    directory => 'BKP_DIR');

  DBMS_DATAPUMP.add_file(
    handle    => l_dp_handle,
    filename  => 'expdpERP.log',
    directory => 'BKP_DIR',
    filetype  => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE);

  DBMS_DATAPUMP.metadata_filter(
    handle => l_dp_handle,
    name   => 'SCHEMA_EXPR',
    value  => '= ''ERP''');

  DBMS_DATAPUMP.start_job(l_dp_handle);

  DBMS_DATAPUMP.detach(l_dp_handle);
END;
/

    Note: Your Oracle Apex database user must have the required privileges to export a schema.