Home » RDBMS Server » Server Utilities » Which takes longer?
Which takes longer? [message #74798] Fri, 18 February 2005 06:08 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Which takes longer?

A hot backup of a 78GB DB on Win2003 during off-peak hours?

or

An export of a 78GB DB on Win2003 with the DB shut down?

I'm inclined to think the hot backup would take longer...am I correct?

Thanks!
Re: Which takes longer? [message #74799 is a reply to message #74798] Fri, 18 February 2005 06:38 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>An export of a 78GB DB on Win2003 with the DB shut down?
How can you take an export when the database is shutdown?
Am i missing something?
>>Which takes longer?
Depends on many many factors.
hardware, your backup method etc.

Studies show that export will take a longer time in VLDB environment ( and consider importing back!!)
Previous Topic: Importing Access Database ( Mdb file) to Oracle
Next Topic: SQLLDR csv input file
Goto Forum:
  


Current Time: Wed Dec 25 19:04:11 CST 2024