exp出来的文件即将超过2G,怎么办?

桐君浪子

没问题的吧，

cjwang_hz

2000下还是做bat文件,让他自动执行更方便.大小也没限制.bat很方便的

eagle_fan

oracle8没有FILESIZE参数

9.0.2直接用filesize就好了

intotherain

哪位能给个明确的解决方案啊？

little_soap

By default, the file size related fields are disabled. They are enabled when you enter more than one filename or file name pattern is specified (for 8i and later)

其实用批命令也蛮好的呀。
查看HELP请输入:
CMD>EXP HELP=Y
简单的例子:
EXP USER/PWD@DBNAME FILE=..... LOG=.... FULL=Y

如果想让它自动运行也可以呀,用傻一点的办法,将EXP命令存成.BAT文件,在OS端定制一个TASK,指明每天几点钟运行这个命令不用可以了么?

little_soap

你可以在OEM的JOB中定义生成几个文件呀，满了2G后会自动生成另一个文件。
图片如下：

yanggq

NTFS没问题阿，FAT32有４G的限制
有些UNIX有2G的　限制

eagle_fan

给你个例子

C:\>exp system/manager@test file=c:\test.dmp full=y

Export: Release 8.1.7.0.0 - Production on Fri Feb 25 15:06:14 2005

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table                    DEF$_AQCALL          0 rows exported
. . exporting table                   DEF$_AQERROR          0 rows exported
. . exporting table                  DEF$_CALLDEST          0 rows exported
. . exporting table               DEF$_DEFAULTDEST          0 rows exported
. . exporting table               DEF$_DESTINATION          0 rows exported
. . exporting table                     DEF$_ERROR          0 rows exported
. . exporting table                       DEF$_LOB          0 rows exported
. . exporting table                    DEF$_ORIGIN          0 rows exported
. . exporting table                DEF$_PROPAGATOR          0 rows exported
. . exporting table       DEF$_PUSHED_TRANSACTIONS          0 rows exported
. . exporting table                  DEF$_TEMP$LOB          0 rows exported
. . exporting table        SQLPLUS_PRODUCT_PROFILE          0 rows exported
. about to export OUTLN's tables via Conventional Path ...
. . exporting table                            OL$          0 rows exported
. . exporting table                       OL$HINTS          0 rows exported
. about to export DBSNMP's tables via Conventional Path ...
. about to export TEST's tables via Conventional Path ...
. . exporting table                            TAB          0 rows exported
. . exporting table                           TEST          0 rows exported
. exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully without warnings.

C:\>dir
Volume in drive C has no label.
Volume Serial Number is 2C49-B933

Directory of C:\

01/20/2005  08:20 AM             2,817 6APDJu.HTM
01/11/2005  03:29 AM                 0 AUTOEXEC.BAT
01/11/2005  03:29 AM                 0 CONFIG.SYS
02/25/2005  08:30 AM               223 CWUtilInst.log
02/20/2005  09:53 PM    <DIR>          Documents and Settings
02/24/2005  03:04 PM    <DIR>          Downloads
02/22/2005  04:33 PM             1,262 kthard_agent.log
01/11/2005  09:28 AM    <DIR>          Notes
02/05/2005  01:19 PM    <DIR>          oracle
02/25/2005  01:29 PM    <DIR>          Program Files
01/31/2005  11:53 AM    <DIR>          Sermodify tool
02/25/2005  03:06 PM           108,544 test.dmp
01/12/2005  12:24 AM    <DIR>          uedit32
02/25/2005  01:00 PM    <DIR>          WINDOWS
01/24/2005  09:53 PM    <DIR>          清风围棋
               6 File(s)        112,846 bytes
               9 Dir(s)     227,688,448 bytes free

C:\>exp system/manager@test filesize=60000 file=c:\test01.dmp,c:\test02.dmp full
=y

Export: Release 8.1.7.0.0 - Production on Fri Feb 25 15:11:30 2005

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
EXP-00075: rounding FILESIZE down, new value is 59392
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table                    DEF$_AQCALL          0 rows exported
. . exporting table                   DEF$_AQERROR          0 rows exported
. . exporting table                  DEF$_CALLDEST          0 rows exported
. . exporting table               DEF$_DEFAULTDEST          0 rows exported
. . exporting table               DEF$_DESTINATION          0 rows exported
. . exporting table                     DEF$_ERROR          0 rows exported
. . exporting table                       DEF$_LOB          0 rows exported
. . exporting table                    DEF$_ORIGIN          0 rows exported
. . exporting table                DEF$_PROPAGATOR          0 rows exported
. . exporting table       DEF$_PUSHED_TRANSACTIONS          0 rows exported
. . exporting table                  DEF$_TEMP$LOB          0 rows exported
. . exporting table        SQLPLUS_PRODUCT_PROFILE          0 rows exported
. about to export OUTLN's tables via Conventional Path ...
. . exporting table                            OL$          0 rows exported
. . exporting table                       OL$HINTS          0 rows exported
. about to export DBSNMP's tables via Conventional Path ...
. about to export TEST's tables via Conventional Path ...
. . exporting table                            TAB          0 rows exported
. . exporting table                           TEST          0 rows exported
. exporting referential integrity constraints
. exporting synonyms
continuing export into file c:\test02.dmp

. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.

C:\>dir
Volume in drive C has no label.
Volume Serial Number is 2C49-B933

Directory of C:\

01/20/2005  08:20 AM             2,817 6APDJu.HTM
01/11/2005  03:29 AM                 0 AUTOEXEC.BAT
01/11/2005  03:29 AM                 0 CONFIG.SYS
02/25/2005  08:30 AM               223 CWUtilInst.log
02/20/2005  09:53 PM    <DIR>          Documents and Settings
02/24/2005  03:04 PM    <DIR>          Downloads
02/22/2005  04:33 PM             1,262 kthard_agent.log
01/11/2005  09:28 AM    <DIR>          Notes
02/05/2005  01:19 PM    <DIR>          oracle
02/25/2005  01:29 PM    <DIR>          Program Files
01/31/2005  11:53 AM    <DIR>          Sermodify tool
02/25/2005  03:06 PM           108,544 test.dmp
02/25/2005  03:11 PM            59,392 test01.dmp
02/25/2005  03:11 PM            51,200 test02.dmp
01/12/2005  12:24 AM    <DIR>          uedit32
02/25/2005  01:00 PM    <DIR>          WINDOWS
01/24/2005  09:53 PM    <DIR>          清风围棋
               8 File(s)        223,438 bytes
               9 Dir(s)     227,463,168 bytes free

chensq

echo %time% >j:\backdb\log\command_%date:~-10%.txt
d:\oracle\ora92\bin\exp.exe file=j:\backdb\xhcb_%date:~-10%.dmp log=j:\backdb\log\xhcb_%date:~-10%.txt userid=xhuser/xhpass@xh  direct=y buffer=40960
c:\PROGRA~1\WinRAR\WinRAR.exe a  j:\backdb\xhcb_%date:~-10%.rar j:\backdb\xhcb_%date:~-10%.dmp >>j:\backdb\log\command_%date:~-10%.txt
del j:\backdb\xhcb_%date:~-10%.dmp >>j:\backdb\log\command_%date:~-10%.txt
d:\oracle\ora92\bin\exp.exe file=j:\backdb\xhfx_%date:~-10%.dmp log=j:\backdb\log\xhfx_%date:~-10%.txt userid=xhfxuser/xhfx@247  direct=y buffer=32768
C:\PROGRA~1\WinRAR\WinRAR.exe a  j:\backdb\xhfx_%date:~-10%.rar j:\backdb\xhfx_%date:~-10%.dmp >>j:\backdb\log\command_%date:~-10%.txt
del j:\backdb\xhfx_%date:~-10%.dmp >>j:\backdb\log\command_%date:~-10%.txt
echo %time% >>j:\backdb\log\command_%date:~-10%.txt

复制为一个批处理文件，并加为Windows任务就Ok了。
我在Win2K+Oracle9.2客户端执行，也没有数据大小的限制，我们的导出数据为十多个G。

eagle_fan

记得
Fat文件限制是4GB
NTFS是TB级的（就是没有限制）