Re: understanding rollback segments

From: The Wils <awislon_at_rci.rogers.com>
Date: 1997/04/25
Message-ID: <33611520.1BD@rci.rogers.com>#1/1

andrew.nelson_at_astramerck.com wrote:
>
> CREATE TABLE FOO AS SELECT * FROM BAR UNRECOVERABLE.
>

Jeez, I wish we had that.
For those who don't, but have SQL*Net you can play with the ARRAYSIZE and COPYCOMMIT variables in SQL*Plus then do a COPY but from the local machine, sneaky eh. This uses TCPIP to copy source_table to target_table, committing 5000 rows at a time.

create table target_table
  tablespace target_tablespace
  storage (initial 200m

           next 50m
           minextents 1
           maxextents 99
           pctincrease 0)

  as select * from schema.source_table
  where rownum < 2;  

truncate table target_table;  

set arraysize 5000
set copycommit 1

copy from user/password_at_t:machine:database -

     insert target_table -
     using select * from source_table;

 

Alan Wilson

---

The man who follows the crowd will usually get no further than the crowd. The man who walks alone is likely to find himself in places no one has ever been.

---

Received on Fri Apr 25 1997 - 00:00:00 CDT