Hi It doesnt seem to say anywhere that i can export the whole 8i database with full=y (including sys and system users) and then import into 10g using full=y(including sys and system) regards Hrishy --- On Thu, 25/6/09, Herald ten Dam <Herald.ten.Dam@xxxxxxxxxxxxxxx> wrote: From: Herald ten Dam <Herald.ten.Dam@xxxxxxxxxxxxxxx> Subject: RE: Oracle8i to 10g upgrade using exp and imp To: "hrishys@xxxxxxxxxxx" <hrishys@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Date: Thursday, 25 June, 2009, 11:20 AM Hi, Oracle has the Oracle Database Upgrade Guide. In this the method is mentioned. See http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i694345. Start reading from the paragraph Export/Import Herald ten Dam Superconsult Van: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] namens hrishy [hrishys@xxxxxxxxxxx] Verzonden: donderdag 25 juni 2009 11:52 Aan: oracle-l@xxxxxxxxxxxxx Onderwerp: Oracle8i to 10g upgrade using exp and imp Hi I would like to know any metalink note or Oracle documentation link which spells out that i can do exp full=y on 8i database and imp full=y into 10g database. I searched this but unable to locate that this is a a supported method for upgrading from 8i to 10g regards Hrishy