-
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
I remember when this place was cool.
-
that should work
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]
Reddy,Sam
-
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]
-
file=file1.dmp,file2.dmp,etc.
-
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
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|