Re: Transaction without any Rollback Segment

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 03 Feb 2000 20:32:48 +0800
Message-ID: <38997570.3AF@yahoo.com>

Thomas Meiers wrote:
>
> Hallo!
>
> I have to do a quite big transaction in my database. I want to import
> data from another database. Is there a way to write data in a table
> directly whithout a rollback segment?
>
> Any help would be great!
>
> Tom

Check out direct load insert (8.0 and above)

There is a good section in "Server Concepts" but in essence

alter table destination_table nologging;

insert /*+ APPEND */
into destination_table
select * from source_table;

HTH
--

---

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 Thu Feb 03 2000 - 06:32:48 CST