Matt:
doesn't need to be pro*c -- you can do it with pl/sql.
I believe this will work:
create or replace procedure LOAD_T_SCN is
cursor c0 is
select rowid,
SCN_DATA
from SCN;
begin
for c1 in c0 loop
update T_SCN
set T_SCN_DATA =c1.SCN_DATA
where rowid = c1.rowid;
end loop;
end;
I have a note to myself that the long needs to be <=
2000 characters, so I hope yours is. Can't remember
why I have this note . . .
Good luck!
Barb
- "Adams, Matthew (GE Consumer & Industrial)"
<MATT.ADAMS_at_GE.COM> wrote:
> I've got a table in an Oracle7.3 database (that I'm
> finally getting
> to upgrade and I'm trying to figure out how to get
> the data from
> the old DB over to the new DB on the new server.
>
> 1) table is too big to export (even sending the
> export to a pipe and =
> thence
> to a compress)
> 2) table contains a long raw, so I cannot use the
> sqlplus COPY command
> 3) table contains a long raw, so I cannot do INSERT
> INTO <DBLINKED =
> TABLE> SELECT * FROM...
> 4) table contains a long raw, so dumping to a flat
> file and re-inserting =
> using
> sqlplus will not work.
>
> Other than writing a Pro*C program to do it myself,
> how can this data be =
> moved?
>
> Matt
>
> ----
> Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
> Just once, I wish we would encounter an
> alien menace that wasn't immune to bullets.=20
> - The Brigadier
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri May 07 2004 - 15:10:58 CDT