Home » RDBMS Server » Server Administration » Creating more Archive logs, how to reduce these Archive log files
Creating more Archive logs, how to reduce these Archive log files [message #50141] Mon, 04 March 2002 00:05 Go to next message
Sunitha
Messages: 16
Registered: January 2000
Junior Member
My Database is in Archive Log Mode. I am migrating around 2000 records from 2 tables to other 8 tables by running the script to migrate data. It is creating lot of archive log files (around 402 mb, I have a problem of system crashing, if I migrate more than 7000 recs). How do I reduce this size. Should I change the script for optimazation or should I do something on the server.

Sunitha

Report message to a moderator

Re: Creating more Archive logs, how to reduce these Archive log files [message #50162 is a reply to message #50141] Mon, 04 March 2002 20:15 Go to previous messageGo to next message
Somu
Messages: 24
Registered: February 2000
Junior Member
Hi,

You can stop the archive log while migrating the records and then startup the archive log.

Report message to a moderator

Re: Creating more Archive logs, how to reduce these Archive log files [message #50175 is a reply to message #50141] Tue, 05 March 2002 04:21 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
May wanna try 'nologging' while copying records to antoher tables. This option has minimal overhead during the process.

Report message to a moderator

Previous Topic: Reg: Oracle8i Custom Installation
Next Topic: Oracle 8.i platform compatibility
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 12:10:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.