Re: &^@#%$@#%$ stinkin' oracle7 database

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@xxxxxx> 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@xxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: