Export in Pl/Sql via DBMS_DATAPUMP
CREATE OR REPLACE PACKAGE maintenance AS PROCEDURE export_myschema; PROCEDURE stop_job (job_name VARCHAR2, schema_name VARCHAR2); PROCEDURE stop_all_jobs; PROCEDURE import_schema (file_name VARCHAR2); END maintenance; / CREATE OR REPLACE PACKAGE BODY maintenance AS PROCEDURE export_myschema AS handle NUMBER; file_name VARCHAR2 (200); log_name VARCHAR2 (200); JOBNAME VARCHAR2 (200); file_prefix VARCHAR2 (30); dir_name VARCHAR2 (4000); l_fexists BOOLEAN; ...