FILESIZE :
- It specifies the maximum size of each dump file. If the size is reached for any member of the dump file set, that file is closed and an attempt is made to create a new file, if the file specification contains a substitution variable.
- You can set filesize parameter limits for the dumpfile size same as below,[FILESIZE=integer[B | K | M | G] where B is bytes, K is KB, M is MB and G is GB]
- The below command will create each dumpfile of size 50ok.If the export data is more than 500k then you specify dumpfile as wildcard “%U” to create multiple files.
[oracle@18c ~]$ expdp hari/oracle directory=test_dir dumpfile=hari_data%U.dmp logfile=hari_data.log schemas=hari filesize=500k Export: Release 18.0.0.0.0 - Production on Tue Aug 21 23:54:36 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "HARI"."SYS_EXPORT_SCHEMA_03": hari/******** directory=test_dir dumpfile=hari_data%U.dmp logfile=hari_data.log schemas=hari filesize=500k Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT . . exported "HARI"."EMP" 873.1 KB 100000 rows . . exported "HARI"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows . . exported "HARI"."SYS_EXPORT_SCHEMA_02" 434.3 KB 1445 rows Master table "HARI"."SYS_EXPORT_SCHEMA_03" successfully loaded/unloaded ****************************************************************************** Dump file set for HARI.SYS_EXPORT_SCHEMA_03 is: /u01/empdata/hari_data01.dmp /u01/empdata/hari_data02.dmp /u01/empdata/hari_data03.dmp /u01/empdata/hari_data04.dmp Job "HARI"."SYS_EXPORT_SCHEMA_03" successfully completed at Tue Aug 21 23:55:06 2018 elapsed 0 00:00:29
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
