RE: &^@#%$@#%$ stinkin' oracle7 database
- From: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 May 2004 20:45:46 -0400
That one thing I thought of, but I'm supposed to have=20
this done by Monday and was looking for something=20
faster. I also came up with an idea that just might be crazy.
I haven't tried it yet, but if I can find a UUENCODE program
that will read standard in and if the unix split program will read
from standard in, I was considering something along the lines of
export writes the data to a pipe, uuencode reads from the pipe, encodes
and pipes it's output to split. I then ftp the uuencode pieces to the
new server, assemble them, uudecode them and load the resultant file
(into a 9i DB which can handle the large export file).
Is this just crazy?
Matt
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Daniel Fink
Sent: Friday, May 07, 2004 4:09 PM
To: oracle-l@xxxxxxxxxxxxx
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=20
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.
>=20
> 1) table is too big to export (even sending the export to a pipe and =
=3D
> 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 =3D
> TABLE> SELECT * FROM...
> 4) table contains a long raw, so dumping to a flat file and =
re-inserting =3D
> using
> sqlplus will not work.
>=20
> Other than writing a Pro*C program to do it myself, how can this data =
be =3D
> moved?
>=20
> Matt
>=20
> ----
> Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx
> Just once, I wish we would encounter an
> alien menace that wasn't immune to bullets.=3D20
> - 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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
