Re: Transaction without Rollback Segment?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 03 Nov 1999 18:47:46 +0800
Message-ID: <382012D2.7F@yahoo.com>

CC wrote:
>
> hi all ,
>
> I 'd like to know if can I define a transaction without using any
> Rollback Segment.
> I want to execute many INSERT INTO... statements without using any
> Rollback Segment. I think is something like SQL Loader's direct path.
>
> 10q

alter table xxx nologging;

insert /*+ APPEND */ into xxx
select ... from other_table;

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 03 1999 - 04:47:46 CST