Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!news.maxwell.syr.edu!news1.optus.net.au!optus!spool01.syd.optusnet.com.au!spool.optusnet.com.au!210.49.20.119.MISMATCH!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <62b0a667.0112120209.6a1e906@posting.google.com> Subject: Re: Database import from Oracle 9i to 8i Date: Wed, 12 Dec 2001 22:07:49 +1100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 25 Message-ID: <3c173a33$0$5903$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: 211.28.77.175 X-Trace: 1008155188 5903 211.28.77.175 Xref: easynews comp.databases.oracle.server:127932 X-Received-Date: Wed, 12 Dec 2001 04:10:03 MST (news.easynews.com) The documentation (should) say no such thing. The 8i version of export will work perfectly well against the 9i database. Read my paper on export versions at the site mentioned below. Many version variations are possible. Regards HJR -- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "Thomas Hyldgaard" wrote in message news:62b0a667.0112120209.6a1e906@posting.google.com... > According to the documentation then it is not possible to use the > "exp" tool for exporting an Oracle9i database and import it on a > Oracle 8 database. > > Does anyone know alternative (preferably command line) tools for > exporting/importing tables? > > Best regards > Thomas