Home » RDBMS Server » Server Administration » Enabe/disable logging
Enabe/disable logging [message #112298] Thu, 24 March 2005 04:13 Go to next message
Tomasz
Messages: 13
Registered: May 2004
Junior Member
Hi guys

A few weeks ago I took to admin oracle db, version 8.1.7. In this db there a lot of tablespace dictionary managed.
I want to ask you:

1. I want to migrate to local managment tb.
I plan to export all objects from my tb
next drop them
next create again with local managemnt
next import to them data
is it correct??

2. I want to speed up index inseertion operation on tb with enabel loggin
Can I disable logging on tb with only index objects??

cheers

Report message to a moderator

Re: Enabe/disable logging [message #112324 is a reply to message #112298] Thu, 24 March 2005 07:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
enabling logging will not speed your operation.
Disable logging or NOLOGGING mode operations run a little faster.
Make sure you backup immediately after this process.

Report message to a moderator

Re: Enabe/disable logging [message #112337 is a reply to message #112298] Thu, 24 March 2005 08:40 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
If you are going to take the time to export everything and recreate it, why not upgrade to 10g (or at least 9iR2) in the process?

Report message to a moderator

Previous Topic: Character set in Database
Next Topic: Extent allocation problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 02:29:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.