Q: copy table functionality in PL/SQL?

From: <rune.slinning_at_bigfoot.com>
Date: Wed, 24 Jun 1998 03:12:24 GMT
Message-ID: <6mpqqo$rel$1@nnrp1.dejanews.com>

Hi!

I need functionality to copy large tables from one schema to another, and it would be nice if I could use the SQL*Plus COPY command from within a PL/SQL procedure. I want to copy the tables in PL/SQL so I can hanle errors/exceptions.

The tables I'll be copying have 450 000+ rows so I need a big rollback segment to copy this with an insert statement like: "insert into ... select * from ..."

Is there anybody out there who have implemented a copy procedure/function using PL/SQL??

Rune

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 23 1998 - 22:12:24 CDT