RE: Exporting Tables from 9i to 7.3 DB

How big are tables? Do you need to keep existing data in the 7.x database?

If the tables are small you can dump them to a flat file using any number of tools and then use SQL*Loader to load them into your 7.x environment.

SQL*Loader has a limit on the amount of records you can load from a flat file though (I think). Its been a while since I used SQL*Loader.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale Sent: Friday, November 09, 2007 8:30 AM
To: jfpark137_at_gmail.com; oracle-l_at_freelists.org Subject: Re: Exporting Tables from 9i to 7.3 DB

You'd have to use an intermediate 8.1.7 database. Generate an 8.1.7 export from the the 9.2.0.4 database, import it into 8.1.7.
Then generate a 7.3 export from the 8.1.7 database.

Hemant

At 08:44 PM Friday, James Parkhurst wrote:
>Anyone know of a process or hack for exporting tables and data from a
>9.2.0.4 DB into a 7.3 export format?
>
>Our company has a product that's used by some partner companies. One
>of these partners is still on 7.3.
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

"There is more to life than increasing its speed." Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l