dmp file [message #341475] |
Tue, 19 August 2008 00:08 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hello,
I have a database of more that 60GB. Am doing a migration and need the latest dmp file. How can i create one as usually a dmp cannot be greater that 2GB.
Thank you,
Dirish
|
|
|
Re: dmp file [message #341477 is a reply to message #341475] |
Tue, 19 August 2008 00:32 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
what is OS?
did you try to export?
you can use "FILESIZE" parameter
FILESIZE maximum size of each dump file
did you using EXP or EXPDP?
what is your ORACLE VERSION?
and why you want to export 60gb database, export is not a backup method.
[Updated on: Tue, 19 August 2008 00:33] Report message to a moderator
|
|
|
|
Re: dmp file [message #341565 is a reply to message #341503] |
Tue, 19 August 2008 06:23 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>usually a dmp cannot be greater that 2GB.
Only for a certain OS.
If you can afford the downtime and you know the pros and cons of export / import process, it is very easy to migrate with exp/import. As said above,
export is not a backup strategy, but meant exactly for this purpose of moving data around.
|
|
|