Home » RDBMS Server » Server Utilities » multi copy of dump file using exp (oracle 10g, windows 7)
multi copy of dump file using exp [message #604048] Mon, 23 December 2013 06:06 Go to next message
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member

i have one question regarding exp utility

in my production database i use exp to take logical backup of my one user and then next day i simply copy this .dmp file and past into another computer drive.

but i mape this my another computer drive into my production database now i want to ask how can i make this multi copy of this my dmp file

means how can we put two copy of .dmp file using exp

i did this below task but only one .dmp create on d drive but now create another .dmp file on e drive. so can i pursue this task can anybody help me into this

F:\oracle\product\10.2.0\db_1\BIN>exp scott/tiger file=D:\ts\1.dmp,E:\tst\2.
dmp  statistics=none

Export: Release - Production on Mon Dec 23 17:03:18 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP         18 rows exported
. . exporting table                       SALGRADE          5 rows exported
. . exporting table                             T1         14 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

[Updated on: Mon, 23 December 2013 06:07]

Report message to a moderator

Re: multi copy of dump file using exp [message #604063 is a reply to message #604048] Mon, 23 December 2013 07:18 Go to previous messageGo to next message
Messages: 21737
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, this:
won't create two copies of the DMP file (one on your D disk drive, another one on E). This is what documentation says (navigate to the FILE parameter):

When Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name specified by the FILE parameter, and continues until complete or the maximum value of FILESIZE is again reached. If you do not specify sufficient export filenames to complete the export, Export will prompt you to provide additional filenames.

In other words, it means that EXP utility will write into your D:\TST\2.DMP until it reaches FILESIZE limit (this parameter specifies maximum size of each DMP file). Then it'll continue export into E:\TST\2.DMP file. If it reaches FILESIZE limit, it will stop and ask you to specify the third (or fourth, fifth etc.) filename until the whole export is done.

Finally, it means that you'd rather create your own (operating system) exporting script (that would be a .BAT in your case) which would a) create one export file on disk D, b) copy it to disk E. Maybe it is possible to do that using EXP itself, but I don't know how to do that.

[Updated on: Mon, 23 December 2013 07:20]

Report message to a moderator

Re: multi copy of dump file using exp [message #605189 is a reply to message #604048] Tue, 07 January 2014 15:37 Go to previous message
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Create a script with the commands to export and copy the file:

SET PGMDIR="F:\oracle\product\10.2.0\db_1\BIN"
cd /D %SRCDIR%
%PGMDIR%\exp scott/tiger file=1.dmp statistics=none
copy 1.dmp %TGTDIR%\2.dmp /B

[Updated on: Wed, 08 January 2014 01:11] by Moderator

Report message to a moderator

Previous Topic: expdp JAVA_CLASS
Next Topic: ORA-01722: invalid number sql* loader
Goto Forum:

Current Time: Mon Aug 15 15:03:41 CDT 2022