| Can I merge two or more exported dumps(*.dmp) ? [message #221500] |
Tue, 27 February 2007 03:48  |
deepakc
Messages: 10
Registered: February 2007
Location: India
|
Junior Member |
|
|
In Oracle 9i, can i merge two or more exported dump(*.dmp) files ?? Plz help me over this.
For example: i have 'test1.dmp' and 'test2.dmp', Can i merge it into a single dump file ??
Thnk u.,
Deepak.C
|
|
|
|
|
|
| Re: Can I merge two or more exported dumps(*.dmp) ? [message #221522 is a reply to message #221510] |
Tue, 27 February 2007 05:19  |
deepakc
Messages: 10
Registered: February 2007
Location: India
|
Junior Member |
|
|
Thank u for ur reply.,
There's a need to do so.,
can i use more than one file name in file parameter of imp command ? like "imp username/passwd file=file1.dmp,file2.dmp" where 'file1.dmp' and 'file2.dmp' are created at different times.
Thnk u.,
Deepak.C
|
|
|
|
|
|
| Re: Can I merge two or more exported dumps(*.dmp) ? [message #221718 is a reply to message #221532] |
Wed, 28 February 2007 03:12 |
deepakc
Messages: 10
Registered: February 2007
Location: India
|
Junior Member |
|
|
Thnk u.,
I look at the Link provided by u for export and import.
When i tried to import two dmp files using the below command, it shows an error. Here 'test1.dmp' and 'test2.dmp' are created using two different exports separately.
imp username/passwd file=test1.dmp,test2.dmp fromuser=test1 touser=test2 log=test.log
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00085: multiple input files specified for unbounded export file
IMP-00000: Import terminated unsuccessfully
Can't i import the dumps at a time created by different exports ?
Thnk u.,
Deepak.C
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Can I merge two or more exported dumps(*.dmp) ? [message #341851 is a reply to message #341846] |
Wed, 20 August 2008 09:58 |
itissiva
Messages: 2
Registered: August 2008
|
Junior Member |
|
|
| Mahesh Rajendran wrote on Wed, 20 August 2008 09:23 | >>Can't i import the dumps at a time created by different exports ?
huh?
Please rephrase the question.
Do you mean to say, merge dumpfiles created by different export sessions? If so, read the posts above.
>>hi, we also help up with multiple sequential dump files. but we used comma separated files. it is working fine. we have 55 dump files in our hand.
Is that a question, or an answer or just a statement?
You mean CSV files? Then look into SQL*Loader or external tables.
|
no, apology for confusion!
actually we tried with 55 *.dmp files, and we succeeded with giving "imp username/password file=file1,file2,file3."
Siva R
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
