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

From: David Kurtz <info_at_go-faster.co.uk>
Date: Fri, 7 May 2004 21:14:08 +0100
Message-ID: <CKEAJBMGFEOCDBFILPJDOEGCDNAA.info@go-faster.co.uk>

Does the size problem also preclude piping the export into an import?

Are you planning to partition the table on the new database? You could break the table into different tables on the 7.3 database,

	export them separately 
	and then import each partition separately.


_________________________

David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz_at_go-faster.co.uk
web: www.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Adams, Matthew (GE Consumer & Industrial)
Sent: 07 May 2004 20:38
To: oracle-l_at_freelists.org
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.

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?

Matt

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com 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_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

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:11:31 CDT