Content-Type: text/plain; charset="us-ascii"
Matt said:
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.
- table is too big to export (even sending the export to a pipe and =
thence
to a compress)
- table contains a long raw, so I cannot use the sqlplus COPY command
- table contains a long raw, so I cannot do INSERT INTO <DBLINKED =
TABLE> SELECT * FROM...
- 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?
Jared replied:
Matt, fairly simple in perl.
The attached files were used to do this from a 7.3 to an 8.1.7 database,
using the DBA_VIEWS
view on the 7.3 database as a source, and 8.1 as a target.
Jared
- Binary/unsupported file stripped by Ecartis --
- Type: application/octet-stream
- File: matt.sh
- Binary/unsupported file stripped by Ecartis --
- Type: application/octet-stream
- File: matt.pl
- Binary/unsupported file stripped by Ecartis --
- Type: application/octet-stream
- File: create.sql
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 - 16:08:52 CDT