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

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 7 May 2004 16:15:34 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AB27@usahm018.exmi01.exch.eds.com>

Daniel, I think that is an interesting idea. If the copy table was created under another user id then the FROMUSER TOUSER import parameters could be used to directly load the export into the target table saving having to complete reverse the process manually.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daniel Fink Sent: Friday, May 07, 2004 4:09 PM
To: oracle-l_at_freelists.org
Subject: 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
>
> ----
>

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:14:26 CDT