Re: Question about Data transfer

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 19 May 1999 20:35:15 +0200
Message-ID: <927138800.12958.0.pluto.d4ee154e@news.demon.nl>

1 No, you can use the exp from Oracle 7 against an Oracle 8 database to accomplish the same.
Make sure you run $ORACLE_HOME/rdbms/admin/catexp7 in svrmgrl first 2 AFAIK no, I usually do this by means of MS-Access and ODBC. Works well 3 Use Access to accomplish this.

Hth,

Sybrand Bakker, Oracle DBA

agi_at_mail.taicom.com.tw wrote in message <7hu4b3$pks$1_at_nnrp1.deja.com>...
>Hi,theres,
> I have some problem about data transfer.
>
> 1.Can I export from 8.0.5 and import into 7.3.3 ??
>
> 2.My DB is 8.0.5 on AIX, can the sqlldr load *.DBF directly ??
>
> 3.What's the most conveninent way to export the table and transfer
> it to DBF file ? ( more than 50,000 rows' table)
>
> Any idea is welcome !!
>Rgds,
>Agi
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Wed May 19 1999 - 13:35:15 CDT