Stupid import question

[Mr.Hanky]

Ok, how do we specify an import if the export uses multiple .DMP files?

In the parfile will the syntax be

File=D:\blah1
File=D:\blah2


I can't find this syntax and I'd like to get this squared away soon since I have to run this into production in about 10 minutes.

Thanks guys;

MH

[sreddy]

import_xyz.sh
::::::::::::::
imp user/***@xyz \
file=/export/oracle/xyz1.dmp, \
/export/oracle/xyz2.dmp, \
export/oracle/xyz3.dmp \
fromuser=xyz touser=xyz ignore=y \
tables=xyz \
buffer=102485760 \
log=import_xyz.log \
commit=y \
feedback=10000

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

[pando]

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]

[stecal]

file=file1.dmp,file2.dmp,etc.

[Mr.Hanky]

THANKS guys, you just saved me some mild headaches.
I am doing europe production now. The ONLY reason we need multiples on this NT box is because winzip can not zip files larger than 4 Gigs.

Thanks Again, you guys rock!

MH