What are the new features of Oracle 10g over Oracle9i?. What are the possible steps to be taken care while migrating data from 9i to 10g ?If possible please list out all the differences between Oracle 9i And 10g.

Interview Candidate
Oct 10th, 2006
3
3186

Showing Answers 1 - 3 of 3 Answers

geetha24
Profile Answers by geetha24 Questions by geetha24

Feb 13th, 2007

New Features of 10g1. Regular Expressions2. Flashback dropped table3. Can send mail using UTL_MAIL4. Datapump utility instead of export and import5. Comparision of nested table6. Sql Tuning advisor9. Pl/sql compile time warning10. Optimizer Dynamic Sampling11.Automatic Statistics using GATHER_STATS_JOB12.New Optimizer hints13. RBO is not supported by Oracle 10g, it still exists for backward compatibility.14.End-end application tracing.