See below.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Karl R." <kreitsch_at_zdnetonebox.com> wrote in message
news:2e361b04.be06502f_at_usw-ex0103-024.remarq.com...
> Hello!
> You have two good chances to succeed;
>
> 1a) Have a look on maxextents on your temporary TS, it could be
> that maxextents is to low.
If you have an issue with maxextents on a temporary tablespace, then the
tablespace isn't set to temporary. That can be a real problem for
performance. A temporary tablespace saves itself a lot of work by not
recording some information that isn't used for temporary operations. If you
have it set as permanent, then you are doing a lot of work in the system
tablespace, and performance will suffer.
>
> 1b) If not then you have to resize the datafile of the TS;
>
> 2) Use a PLS/SQL For-Loop ...
>
> NN PLS_INTEGER := 0;
> FOR REC IN ( SELECT * FROM TABLE1 )
> DO
> INSERT INTO TABLE2 (col1, col2) Values ( REC.col2,
> Rec.col2 ...);
> NN := nn +1;
> IF ( MOD(NN , 1000) = 0
> Commit;
> END IF;
>
You can also use the copy statement in sqlplus.
>
>
> ...;
> DONE
>
> -- Do not forget last commit;
> Commit;
>
>
> Please check syntax i made it quickly
>
> Bye
>
>
> Karl Reitschuster
> Senior Consultant CSC Ploenzke AG
> Oracle Databases, Implementation, Performance-Tuning
> <!Jesus is Lord!>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Fri May 26 2000 - 00:00:00 CDT
