#Error while exporting data into multiple dumps. C:\Windows\System32>expdp directory=DIR_TEST schemas=test dumpfile=schema_%U.dmp logfile=schema.log filesize=10k Export: Release 19.0.0.0.0 - Production on Fri Mar 15 20:23:53 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates. All rights reserved. Username: test Password: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31618: FILESIZE is outside valid range of 40KB to 16TB Cause: The specified filesize value i.e. 10K is outside the range of 40KB to 16 TB. Solution: #specify the filesize value in the range of 40KB to 16 TB. C:\Windows\System32>expdp directory=DIR_TEST schemas=test dumpfile=schema_%U.dmp logfile=schema.log filesize=40k Export: Release 19.0.0.0.0 - Production on Fri Mar 15 20:24:09 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates. All rights reserved. Username: test Password: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "TEST"."SYS_EXPORT_SCHEMA_01": test/******** directory=DIR_TEST schemas=test dumpfile=schema_%U.dmp logfile=schema.log filesize=40k 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/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/TABLESPACE_QUOTA 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/VIEW/VIEW Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT . . exported "TEST"."DEPT" 6.531 KB 5 rows . . exported "TEST"."EMP" 6.531 KB 5 rows Master table "TEST"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for TEST.SYS_EXPORT_SCHEMA_01 is: C:\BACKUP\SCHEMA_01.DMP C:\BACKUP\SCHEMA_02.DMP C:\BACKUP\SCHEMA_03.DMP C:\BACKUP\SCHEMA_04.DMP C:\BACKUP\SCHEMA_05.DMP C:\BACKUP\SCHEMA_06.DMP C:\BACKUP\SCHEMA_07.DMP C:\BACKUP\SCHEMA_08.DMP C:\BACKUP\SCHEMA_09.DMP C:\BACKUP\SCHEMA_10.DMP C:\BACKUP\SCHEMA_11.DMP Job "TEST"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Mar 15 20:24:39 2024 elapsed 0 00:00:26 You can see in the below screen, the export dumps are created with equal size i.e. 40 KB each and the last dumpfile with remaining size.  |
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !
Thank you for your comment !