Oracle 10g: Exploring Data Pump - The Diigo Meta page

• 27 Nov 07
  

  TooManySecrets

  Documento donde aparte de explicar el tema del uso, etc, de las importaciones/exportaciones de datos con el oracle, indica cómo crear el directorio DATA PUMP DIR en el oracle, que es donde/desde se realizaran las importaciones/exportaciones en el oracle.

  datapumpdirectory data_pump_directory oracle impdp expdp dba sysadmin exportacion importacion documentacion

  • SQLPLUS system/manager@TDB10G as sysdba  SQL> create user dpuser identified by dpuser; SQL> grant connect, resource to dpuser; SQL> CREATE DIRECTORY dpump_dir1 AS '/opt/app/oracle'; SQL> grant read, write on directory dpump_dir1 to dpuser
• 27 Oct 06
  

  athar
  • Declare P_handle number; --- -- Data Pump job handle P_last_job_state varchar2(45); ---- -- To keep track of job state P_job_state varchar2(45); P_status ku$_Status ----- -- The status object returned by get_status BEGIN P_handle:=DBMS_DATAPUMP.OPEN ('EXPORT','SCHEMA', NULL,'EXAMPLE','LATEST'); -- Specify a single dump file for the job (using the handle just returned) -- and a directory object, which must already be defined and accessible -- to the user running this procedure DBMS_DATAPUMP.ADD_FILE (p_handle,'example.dmp','DMPDIR'); -- A metadata filter is used to specify the schema that will be exported. DBMS_DATAPUMP.METADATA_FILTER (p_handle,'SCHEMA_EXPR','IN (''dpuser'')'); -- Start the job. An exception will be generated if something is not set up -- Properly. DBMS_DATAPUMP.start_job (p_handle); ----The export job should now be running.

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.