RE: &^@#%$@#%$ stinkin' oracle7 database
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 May 2004 15:58:29 -0400
You ruled out exp w/ compress. How about exp to a named pipe,=20
(optionally compress), ssh across network, (optionally decompress),
dump data into another named pipe, imp from named pipe.
Second option, SQL*Plus 'copy' command.
-Mark
PS With either of the above solutions, you may consider dedicated Gig-E =
connections with dedicated listeners and distinct dedicated service =
names, and multiple pipes concurrently to speed things up, if you've got =
lots of tables.
-----Original Message-----
From: Adams, Matthew (GE Consumer & Industrial)
[mailto:MATT.ADAMS@xxxxxx]
Sent: Friday, May 07, 2004 3:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: &^@#%$@#%$ stinkin' oracle7 database
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 =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.
Other than writing a Pro*C program to do it myself, how can this data be =
=3D
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.=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
-----------------------------------------------------------------
Other related posts:
