Xref: alice comp.databases.oracle.server:33563
Path: alice!news-feed.fnsi.net!news.idt.net!woodstock.news.demon.net!demon!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Redo-Logs = NO?
Date: Wed, 11 Nov 1998 23:21:21 +0100
Message-ID: <364A0DE1.A9E18B02@sybrandb.demon.nl>
References: <72clsr$3j7$1@nnrp1.dejanews.com>
X-Trace: news.demon.nl 910822788 spot:11286 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@demon.net
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
To: hgvogel@my-dejanews.com
Content-Type: multipart/mixed; boundary="------------99D56F96002C6595B821736F"
Lines: 68
--------------99D56F96002C6595B821736F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Helmut,

I am afraid you are mixing up several things. First of all: redo log files are
vital, you can't switch them of completely. You can run a database in
noarchivelog mode, and you shouldn't definitely do that in a production
situation. Actually having the redo logs, which is a roll forward image (which
is completely different from a rollback segment) allows Oracle to piggy-back
transactions, and postpone writes to the database, thus minimising the number
of database writes. Please consult the Oracle Server Concepts manual for
further details.

Then, as to the ora-1552 error. To create a second tablespace, there must be a
second rollback segment in the system tablespace. This is necessary only once,
and the segment can be put offline after creation of the second tablespace.
You should have a separate tablespace dedicated to rollback segments, and the
rollback segments should either be public, or private and listed in the
init<sid>.ora. If you have rollback segments outside the system tablespace,
they are probably offline because they are private and have not been listed in
the init<sid>.ora. In a normal production situation only the SYSTEM rollback
segment (which exists by design in the tablespace system and is used to commit
DDL-transactions) should be enabled.

Hth,
Sybrand Bakker, Oracle DBA

hgvogel@my-dejanews.com wrote:

> Hi!
>
> Is it possible to have a non-system-tablespace without a rollback-segment?
> When I tried to insert data, I got error ORA-01552.
> I don't want to use redo-logs because I always can restart the job using
> existing input data.
> And it's also for better performance!
>
> I'm using Workgroup Server Rel. 7.3.4 on Windows NT 4.0.
> Can anybody help? Thank You.
>
> Helmut
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own



--------------99D56F96002C6595B821736F
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Sybrand Bakker
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Sybrand Bakker
n:              Bakker;Sybrand
email;internet: postbus@sybrandb.demon.nl
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


--------------99D56F96002C6595B821736F--