Re: Redo-Logs = NO?

From: <satar_at_my-dejanews.com>
Date: Thu, 12 Nov 1998 00:52:09 GMT
Message-ID: <72dbfp$mdm$1@nnrp1.dejanews.com>

You can have tablespaces without rollback segments physically residing in them (in the datafiles). However, you cannot have a database without Rollback segments.

Satar

In article <72clsr$3j7$1_at_nnrp1.dejanews.com>, hgvogel_at_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
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 11 1998 - 18:52:09 CST