This discussion is archived
2 Replies Latest reply: Nov 14, 2013 10:31 PM by DK2010 RSS

Is it possible in 9i to take export backup in two different mount point

25766010-2196-4085-9921-c59990af6386 Newbie
Currently Being Moderated

Hello Team,

 

Is it possible in 9i to take export in two different mount point with file size 22 gb.

 

exp owner=PERFSTAT FILE =/global/nvishome5/oradata/jlrvista/PERFSTAT_exp01.dmp,/global/nvishome4/oradata/jlrvista/export/PERFSTAT_exp02.dmp FILESIZE=22528

 

I tried with above but no luck..so later killed session

 

prs72919-oracle:/global/nvishome5/oradata/jlrvista$ exp owner=SLENTON FILE =/global/nvishome5/oradata/jlrvista/PERFSTAT_exp01.dmp,/global/nvishome4/oradata/jlrvista/export/PERFSTAT_exp02.dmp FILESIZE=2048

 

 

Export: Release 9.2.0.8.0 - Production on Thu Nov 14 13:25:54 2013

 

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

 

 

 

Username: / as sysdba

 

 

Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.8.0 - Production

Export done in US7ASCII character set and UTF8 NCHAR character set

server uses UTF8 character set (possible charset conversion)

 

 

About to export specified users ...

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user SLENTON

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user SLENTON

continuing export into file /global/nvishome4/oradata/jlrvista/export/PERFSTAT_exp02.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

About to export SLENTON's objects ...

. exporting database links

. exporting sequence numbers

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

. exporting cluster definitions

. about to export SLENTON's tables via Conventional Path ...

. . exporting table                      G_AUTHORS

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp >

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp > ps -ef | grep exp

 

 

continuing export into file ps -ef | grep exp.dmp

 

 

Export file: expdat.dmp > ^C

 

 

continuing export into file expdat.dmp

 

 

EXP-00056: ORACLE error 1013 encountered

ORA-01013: user requested cancel of current operation

. . exporting table                        G_BOOKS

Export file: expdat.dmp > ^C

 

 

continuing export into file expdat.dmp

 

 

EXP-00056: ORACLE error 1013 encountered

ORA-01013: user requested cancel of current operation

. . exporting table                 G_BOOK_AUTHORS

Export file: expdat.dmp > ^C

 

 

continuing export into file expdat.dmp

 

 

Export file: expdat.dmp > Killed