Home » RDBMS Server » Server Utilities » Can I merge two or more exported dumps(*.dmp) ?
Can I merge two or more exported dumps(*.dmp) ? [message #221500] Tue, 27 February 2007 03:48 Go to next message
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 #221510 is a reply to message #221500] Tue, 27 February 2007 04:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No.
Why do you want to such exotic things?
Re: Can I merge two or more exported dumps(*.dmp) ? [message #221522 is a reply to message #221510] Tue, 27 February 2007 05:19 Go to previous messageGo to next message
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 #221532 is a reply to message #221522] Tue, 27 February 2007 05:52 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you'd be interested in reading Export and Import Utilities guide. It describes all you ever wanted to know about them (including syntax and parameters one can use).
Re: Can I merge two or more exported dumps(*.dmp) ? [message #221718 is a reply to message #221532] Wed, 28 February 2007 03:12 Go to previous messageGo to next message
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 #221737 is a reply to message #221718] Wed, 28 February 2007 04:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Here 'test1.dmp' and 'test2.dmp' are created using two different exports separately.
Not possible.
Multiple input files for imp will work only if the dumps where created using the same exp process (using FILESIZE/FILE).
Re: Can I merge two or more exported dumps(*.dmp) ? [message #221745 is a reply to message #221737] Wed, 28 February 2007 04:58 Go to previous messageGo to next message
deepakc
Messages: 10
Registered: February 2007
Location: India
Junior Member
ok., Thnk u Very much.

Deepak.C
Re: Can I merge two or more exported dumps(*.dmp) ? [message #341840 is a reply to message #221745] Wed, 20 August 2008 09:04 Go to previous messageGo to next message
itissiva
Messages: 2
Registered: August 2008
Junior Member

Can't i import the dumps at a time created by different exports ?

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.

Regards,
Siva R
Re: Can I merge two or more exported dumps(*.dmp) ? [message #341846 is a reply to message #341840] Wed, 20 August 2008 09:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>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.
Re: Can I merge two or more exported dumps(*.dmp) ? [message #341851 is a reply to message #341846] Wed, 20 August 2008 09:58 Go to previous messageGo to next message
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
Re: Can I merge two or more exported dumps(*.dmp) ? [message #341852 is a reply to message #341851] Wed, 20 August 2008 10:02 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Ofcourse,
that works. It is the supported method. You are importing dumpfiles created from a session. This year and half old topic is about merging dump files created in different sessions.
Previous Topic: Error ORA-00922: during Importing dmp file
Next Topic: Error while doing an expdp for a large datafile
Goto Forum:
  


Current Time: Sat Dec 03 00:51:10 CST 2016

Total time taken to generate the page: 0.10221 seconds