expdp在限定檔案大小時,注意dump檔名字變化【zt】
使用expdp限定檔案大小,使用filesize
注意一點在限定檔案大小時,注意dump檔名字變化.
測試如下
directory dumpdir as '/data01' ;
Directory created.
write,read on directory dumpdir to yxyup ;
Grant succeeded.
#expdp yxyup/password dumpfile=yxyup.dump directory=dumpdir filesize=2m
Export: Release 10.2.0.3.0 - Production on Thursday, 28 August, 10:46:57
Copyright (c) 2003, 2005, . All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Starting "YXYUP"."SYS_EXPORT_SCHEMA_01": yxyup/******** dumpfile=yxyup.dump directory=dumpdir filesize=2m
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 12 MB
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/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
ORA-39095: Dump file space has been exhausted: Unable to allocate 4096 bytes
---以上可以看到在絕對固定dump出來的檔案時,報錯.
使用%U,使檔名順序產生.
#expdp yxyup/password dumpfile=yxyup_%U.dump directory=dumpdir filesize=2m
Export: Release 10.2.0.3.0 - Production on Thursday, 28 August, 2008 10:51:45
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Starting "YXYUP"."SYS_EXPORT_SCHEMA_04": yxyup/******** dumpfile=yxyup_%U.dump directory=dumpdir filesize=2m
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 13 MB
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/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "YXYUP"."TEST01" 4.706 MB 50400 rows
. . exported "YXYUP"."TEST_BAK" 4.706 MB 50397 rows
. . exported "YXYUP"."SYS_EXPORT_SCHEMA_03" 309.6 KB 1081 rows
. . exported "YXYUP"."SYS_EXPORT_SCHEMA_02" 224.8 KB 1074 rows
. . exported "YXYUP"."SYS_EXPORT_SCHEMA_01" 139.4 KB 1063 rows
Master table "YXYUP"."SYS_EXPORT_SCHEMA_04" successfully loaded/unloaded
******************************************************************************
Dump file set for YXYUP.SYS_EXPORT_SCHEMA_04 is:
/data01/yxyup_01.dump
/data01/yxyup_02.dump
/data01/yxyup_03.dump
/data01/yxyup_04.dump
/data01/yxyup_05.dump
/data01/yxyup_06.dump
Job "YXYUP"."SYS_EXPORT_SCHEMA_04" successfully completed at 10:51:53
#ll
total 21664
-rw-r--r-- 1 oracle dba 13 Aug 8 23:19 a.txt
-rw-r--r-- 1 oracle dba 2188 Aug 28 10:51 export.log
drwx------ 2 oracle dba 16384 Aug 8 23:06 lost+found
-rw-r----- 1 oracle dba 2097152 Aug 28 10:51 yxyup_01.dump
-rw-r----- 1 oracle dba 2097152 Aug 28 10:51 yxyup_02.dump
-rw-r----- 1 oracle dba 2097152 Aug 28 10:51 yxyup_03.dump
-rw-r----- 1 oracle dba 2097152 Aug 28 10:51 yxyup_04.dump
-rw-r----- 1 oracle dba 2097152 Aug 28 10:51 yxyup_05.dump
-rw-r----- 1 oracle dba 565248 Aug 28 10:51 yxyup_06.dump
-rw-r----- 1 oracle dba 11030528 Aug 28 10:50 yxyup.dump
http://space.itpub.net/7364032/viewspace-438681
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/90618/viewspace-700295/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [原創] expdp在限定檔案大小時,注意dump檔名字變化
- 工具新特性2-expdp 加密dump檔案集加密
- 改變歸檔日誌檔案大小
- 工具新特性1-expdp 壓縮dump檔案集
- SQL Server 監視資料檔案大小變化SQLServer
- 改變日誌檔案大小
- dump日誌檔案
- 10g 資料泵(Data Dump) -- EXPDP & IMPDP [zt]
- 得到檔案大小
- Oracle 跟蹤檔案和檔案轉儲(dump)Oracle
- Oracle:dump轉儲檔案Oracle
- lucene索引檔案大小優化小結索引優化
- dump備份並定時刪除過去檔案
- 限制檔案大小及顯示檔案大小(正規表示式
- archive log檔案大小與redo log檔案大小關係探究Hive
- java 獲取資料夾大小、檔案大小、檔案個數Java
- alert log檔案的變化
- 使用awk來解析dump檔案
- dump 轉儲檔案內容
- pdf檔案太大如何變小 減小pdf檔案大小最簡單的方法
- Lucene索引檔案大小優化方案總結索引優化
- fgets讀取檔案時的注意事項
- oralce密碼檔案要注意SID的大小寫問題密碼
- Oracle檔案頭資訊(zt)Oracle
- 【maven】Maven打包後為何檔案大小改變了Maven
- Windows 快速統計檔案列表中檔案大小Windows
- windows下檔案系統支援的檔案大小Windows
- 檔案-臨時檔案
- 表空間&資料檔案和控制檔案(zt)
- 『前端開發』- 字型檔案大小優化實踐前端優化
- 【Addressable】Catalog檔案大小最佳化
- java 讀取.txt檔案時,注意的問題Java
- 修改上傳檔案大小
- 日誌檔案的大小
- 增大redo log檔案大小
- expdp在匯出時對資料大小進行評估
- 增加日誌檔案,修改當前日誌檔案大小
- vue ElementUI upload上傳檔案時對檔案格式、大小和寬高的限制VueUI