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

Matt,

This may be a stupid idea, so feel free to beat me about the head and shoulders 
at our next meeting...

Could you create subsets of the larger table in smaller tables by using a 
create table as select with a predicate? Then you could 
export the smaller tables as separate units. Of course, this also means 
reversing the process on the import.

Daniel Fink

Adams, Matthew (GE Consumer & Industrial) 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
> -----------------------------------------------------------------


----------------------------------------------------------------
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: