Do export of table using FIELSIZE parameter.

[tiger5]/u08/users/sadavid/SD815> exp sadavid/sadavid tables=test_table
file=sadavid.dmp log=exp1.log filesize=50K

Export: Release 8.1.5.0.0 - Production on Thu Oct 14 15:43:05 1999

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


Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table TEST_TABLE
Export file: expdat.dmp > sadavid1.dmp

continuing export into file sadavid1.dmp

Export file: expdat.dmp > sadavid2.dmp

continuing export into file sadavid2.dmp

Export file: expdat.dmp > sadavid3.dmp

continuing export into file sadavid3.dmp

Export file: expdat.dmp > sadavid4.dmp

continuing export into file sadavid4.dmp

Export file: expdat.dmp > sadavid5.dmp

continuing export into file sadavid5.dmp
2693 rows exported
Export terminated successfully without warnings.
[tiger5]/u08/users/sadavid/SD815>


4. Truncate test_table and then do import.

*NOTE: If you do not use FILESIZE=50K in your import, you will
get an IMP-00046: using FILESIZE value from export file
of 51200 but the import does complete successfully.

[tiger5]/u08/users/sadavid/SD815> imp sadavid/sadavid file=sadavid.dmp
tables=test_table ignore=y log=imp1.log

Import: Release 8.1.5.0.0 - Production on Thu Oct 14 16:04:11 1999

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


Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

Export file created by EXPORT:V08.01.05 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
IMP-00046: using FILESIZE value from export file of 51200
. importing SADAVID's objects into SADAVID
. . importing table "TEST_TABLE"
Import file: expdat.dmp > sadavid1.dmp

Enter name of the next file in the export file set.
Import file: expdat.dmp > sadavid2.dmp

Enter name of the next file in the export file set.
Import file: expdat.dmp > sadavid3.dmp

Enter name of the next file in the export file set.
Import file: expdat.dmp > sadavid4.dmp

Enter name of the next file in the export file set.
Import file: expdat.dmp > sadavid5.dmp
2693 rows imported
Import terminated successfully with warnings.
[tiger5]/u08/users/sadavid/SD815>



you dont specify each file's name you specify the export file name specified when you export

but seems like there are several ways of doing it, check Note 75109.1

[Edited by pando on 08-07-2002 at 02:59 PM]