How to export the dumpfile default directory location in Oracle database 19C
Posted by Mir Sayeed Hassan on December 8th, 2024
How to export the dumpfile default directory location in Oracle database 19C
Check the database version
SYS> select name, status, open_mode, version from V$database, v$instance; NAME STATUS OPEN_MODE VERSION ---------------------------------------------- ORA19CDB OPEN READ WRITE 19.0.0.0.0
The name of the default directory is “DATA_PUMP_DIR” and directory name convention as dumfile name “export.dmp” logfile name “export.log”
Note: No need to create the OS Level & DB level directory when you are using the default directory for dumpfile backup.
Identify the default directory in database
SYS> col directory_name for a20 SYS> col directory_path for a40 SYS> select owner, directory_name, directory_path from dba_directories where directory_name like '%DATA_PUMP_DIR'; OWNER DIRECTORY_NAME DIRECTORY_PATH ---------------------------------------------------------------------- SYS DATA_PUMP_DIR /u01/app/oracle/admin/oradb19c/dpdump/
Start export of the schema “HASSAN” by using default directory location
[oracle@oradb19c ~]$ expdp schemas=hassan Export: Release 19.0.0.0.0 - Production on Sun Dec 08 05:37:14 2024 Version 19.18.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA schemas=hassan Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX . . exported "HASSAN"."BOWIE" 688.8 KB 10000 rows . . exported "HASSAN"."ADD_PICTURE" 0 KB 0 rows . . exported "HASSAN"."T1" 5.632 KB 9 rows Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is: /u01/app/oracle/admin/oradb19c/dpdump/expdat.dmp Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Sun Dec 08 05:37:53 2024 elapsed 0 00:00:36
Verify the files place in default directory as shown below.
[oracle@oradb19c ~]$ cd /u01/app/oracle/admin/oradb19c/dpdump/
[oracle@oradb19c dpdump]$ ll total 1092 -rw-r-----. 1 oracle oinstall 159 Jun 10 2023 dp.log -rw-r-----. 1 oracle oinstall 1101824 Dec 08 05:37 expdat.dmp -rw-r--r--. 1 oracle oinstall 1658 Dec 08 05:37 export.log -rw-r--r--. 1 oracle oinstall 1772 Dec 08 05:27 hassan.log