Home » RDBMS Server » Server Utilities » dmp file (oracle8)
dmp file [message #341475] Tue, 19 August 2008 00:08 Go to next message
dirish
Messages: 205
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 Go to previous messageGo to next message
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 #341503 is a reply to message #341477] Tue, 19 August 2008 02:22 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
solaris
oracle8

am using exp/imp
Re: dmp file [message #341565 is a reply to message #341503] Tue, 19 August 2008 06:23 Go to previous message
Mahesh Rajendran
Messages: 10672
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.



Previous Topic: importing into em with dmp file
Next Topic: Error ORA-00922: during Importing dmp file
Goto Forum:
  


Current Time: Sat Dec 03 00:58:20 CST 2016

Total time taken to generate the page: 0.12034 seconds