Home » RDBMS Server » Server Administration » Data Archiving
Data Archiving [message #227503] Wed, 28 March 2007 07:33 Go to next message
saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad
Junior Member
How to do Archiving in Oracle 9i
Re: Data Archiving [message #227511 is a reply to message #227503] Wed, 28 March 2007 07:47 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I assume you mean archivelog ? Check Changing the Database Archiving Mode.
Re: Data Archiving [message #227714 is a reply to message #227511] Thu, 29 March 2007 02:48 Go to previous messageGo to next message
saikatermail
Messages: 20
Registered: November 2006
Location: Hyderabad
Junior Member
Data Archiving Means To take the Backup of History Tables in a External Device such as Tape with the same layout.

Re: Data Archiving [message #227734 is a reply to message #227714] Thu, 29 March 2007 04:03 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Not really sure what you mean by "same layout", but one method to archive data is to use EXPORT. You could dump the data to disk and then copy to tape.
Previous Topic: how to get the output from dbms_job written to a file
Next Topic: Oracle and Windows Clusters
Goto Forum:
  


Current Time: Sun Dec 11 00:31:04 CST 2016

Total time taken to generate the page: 0.16756 seconds