- 24 Nov, 2023
- 0 Comments
- 1 Min Read
Datapump Export To ASM Diskgroup (EXPDP)
It is very common to export dump file to the standard file system(Mount points).
However, we can export the dump files to ASM diskgroup also.
Follow the Below Steps :
1.Create a directory pointing to ASM diskgroup( for dump files)
1 2 3 4 5 6 7 | SQL> create directory SOURCE_DUMP as '+NEWTST/TESTDB2/TEMPFILE';Directory created.SQL> grant read,write on directory SOURCE_DUMP to public;Grant succeeded. |
2.Create a directory pointing to normal filesystem ( for logfiles)
1 2 3 | SQL> create directory EXPLOG as '/export/home/oracle';Directory created. |
3.Run expdp command:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | expdp dumpfile=test.dmp logfile=test.log directory=SOURCE_DUMP tables=dbatest.EMPTAB exclude=statisticsExport: Release 12.1.0.2.0 - Production on Wed Feb 8 10:07:54 2017Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.Username: / as sysdbaConnected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Advanced Analytics and Real Application Testing optionsStarting "SYS"."SYS_EXPORT_TABLE_01": /******** AS SYSDBA dumpfile=test.dmp logfile=EXPLOG:test.log directory=SOURCE_DUMP tables=dbatest.EMPTAB exclude=statisticsEstimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 11 MBProcessing object type TABLE_EXPORT/TABLE/TABLE. . exported "DBATEST"."EMPTAB" 8.691 MB 81753 rowsMaster table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded******************************************************************************Dump file set for SYS.SYS_EXPORT_TABLE_01 is:+NEWTST/TESTDB2/tempfile/test.dmp ---- >>> Dump file created in ASM DISKGROUP.Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Sat Nov 24 10:08:13 2024 elapsed 0 00:00:15 |