Ron
You could try getting the 7.3.4 export to run against the 8.1.7 database.
I don't know if the 32 vs 64 bit would affect you. Also, datafile formats
changed between Oracle 7 and 8 and I haven't tried this particular export.
Maybe somebody on the list has.
Dennis Williams
DBA, 80%OCP, 100%
Smith, Ron L. wrote:
I need to export the data from an Oracle 8.1.7 database HPUX 64 and
import it back into an old 7.3.4 HPUX 32 database.
The 7.3.4 import doesn't like the 8.1.7 export file.
Any ideas?
Ron Smith
I am unsure whether a 7.3.4 client can talk to a 8.1.7 database. It
Ron,
Something I forgot and which Dennis' remark about format reminded me
of :
You'll probably have to run $ORACLE_HOME/rdbms/admin/catexp7.sql againts
your 8.1.7 database before you can use the Oracle7 exp against it (and
run catexp again once you're done). File formats should be OK if your
If 8.1.7 is production, then I would use selects, sql loader. If you are
REAL industrious, you can try exp with 8.1.7 exp, then imp with show=y to
generate a big nasty mess of text that you can try whipping up on with sed
and/or awk to clean up.
If 8.1.7 is a slam and bang around database, it