Robert,
Thanks for point that out. Also, if there is index on the table,
redo will still be generated for index.
Richard
-----Original Message-----
Sent: Tuesday, January 28, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
/*+ append */ alone does not prevent redo generation. Only with NOLOGGING in
the SQL
will redo generation be suppressed.
Cheers!
RF
-----Original Message-----
Sent: Tuesday, January 28, 2003 6:29 PM
To: Multiple recipients of list ORACLE-L
If it's a lot of rows and looks like you are archiving it to
a historical table, you could do:
insert /*+ append */ into target_table select * from source_table;
this will do a direct path insert, so it uses space above HWM.
It doesn't generate redo.
Richard
-----Original Message-----
Sent: Tuesday, January 28, 2003 6:09 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Please forgive this newbie question; I'm just getting started with PL/SQL.
I want to write a procedure to copy all rows from one table to another one
with an identical structure. The table has many rows so I'm committing
every thousand records (error handling to be added later). The table has
50+ columns and (if possible) I'd like to avoid listing them all in the
VALUES clause. I'm not just being lazy - I hope to deploy this code to
several databases and the source table, while having the same name, may have
differences in the columns. I want to do something like this:
DECLARE
count_ NUMBER;
CURSOR get_archive_records IS
SELECT * FROM customer_order_table;
BEGIN
count_ := 0;
FOR rec_ IN get_archive_records LOOP
INSERT INTO customer_order_archive
VALUES (rec_.*); -- OBVIOUSLY, THIS DOES NOT WORK
count_ := count_ + 1;
IF MOD(count_,1000) = 0 THEN
COMMIT;
END IF;
END LOOP;
COMMIT;
END;
Is there a way to accomplish this? Or is my whole approach all wrong?
Thanks in advance,
Beth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Beth Wells
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Ji
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Freeman
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Ji
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
