Hi Joel hehe you got me confused .But what i understood from the documentation is ful export and full import is supported regards Hrishy --- On Thu, 25/6/09, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> wrote: From: Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> Subject: RE: Oracle8i to 10g upgrade using exp and imp To: hrishys@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx, Herald.ten.Dam@xxxxxxxxxxxxxxx Date: Thursday, 25 June, 2009, 3:17 PM Yes, but when I read something like ‘followed by a full or partial import’…in oracle documentation, it leaves me ambiguous as to what happens to the existing system schema in the destination database, and the consequences thereof. Joel Patterson Database Administrator 904 727-2546 From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of hrishy Sent: Thursday, June 25, 2009 9:55 AM To: oracle-l@xxxxxxxxxxxxx; Herald ten Dam Subject: RE: Oracle8i to 10g upgrade using exp and imp Hi Hearld Thank you very much i appreciate the highlighting to reinforce the way i read the documentation and confirming it. 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: "hrishy" <hrishys@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Date: Thursday, 25 June, 2009, 1:23 PM Hi, the paragraph states: Export/Import Unlike the DBUA or a manual upgrade, the Export/Import utilities physically copy data from your current database to a new database. You can use either the Oracle Data Pump Export and Import utilities (available as of Oracle Database 10g) or the original Export and Import utilities to perform a full or partial export from your database, followed by a full or partial import into a new Oracle Database 10g database. Export/Import can copy a subset of the data in a database, leaving the database unchanged. I think above paragraph states the use of full for both Export as Import. Herald ten Dam Superconsult Van: hrishy [hrishys@xxxxxxxxxxx] Verzonden: donderdag 25 juni 2009 12:36 Aan: oracle-l@xxxxxxxxxxxxx; Herald ten Dam Onderwerp: RE: Oracle8i to 10g upgrade using exp and imp 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