I have upgraded 12 databases to 10g. I have used 2. Manual upgrade and 3. Created a 10g database and migrated the data. I used # 3 when I changed the characterset and #2 when I was migrating a database from the same characterset. Also, I used #3 for all my 8.1.7.4 databases and #2 for all my 9i databases. Sandra Arnold ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams Sent: Monday, March 05, 2007 12:22 PM To: Oracle Discussion List Subject: 10g upgrade survey List, If you've upgraded more than one database to 10g, please let me know what method you chose: 1. dbua 2. Manual upgrade 3. Created a 10g database and migrated the data. Either reply to the list or to me directly. Also please let me know why you chose the path you selected and if you had to do it again if you'd done it differently. Thanks, Dennis Williams