Home » SQL & PL/SQL » SQL & PL/SQL » difference between oracle 8i and 9i
difference between oracle 8i and 9i [message #33077] Sun, 19 September 2004 08:27 Go to next message
Rajdeep Dhal
Messages: 1
Registered: September 2004
Junior Member
Dear sir,

           I am very eager to know about the difference between Oracle 8i and Oracle 9i.

                         With regards i remain 

                                                                              your's sincerely

                                                                               Rajdeep Dhal
Re: difference between oracle 8i and 9i [message #33078 is a reply to message #33077] Sun, 19 September 2004 12:53 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
Every version of Oracle includes a new features guide, as part of the documentation, that tells you what is new and different since the previous version. So, if you click on the link below for the 9i new features guide, it will give you the differences between 8i and 9i. You may be required to register with OTN (Oracle Technology Network), but it is free. You can access all of the documentation for all of the versions online through OTN.

Re: difference between oracle 8i and 9i [message #33531 is a reply to message #33077] Sun, 17 October 2004 05:13 Go to previous messageGo to next message
JESURAJ SELWYN
Messages: 1
Registered: October 2004
Junior Member
Please send complete details immediately
Re: difference between oracle 8i and 9i [message #33603 is a reply to message #33077] Thu, 21 October 2004 03:22 Go to previous messageGo to next message
Kumar Abhishek
Messages: 1
Registered: October 2004
Junior Member
hello frnds


can any one tell me that what is the difference between oracle 8i and oracle 9i

its urgent for me

i ll very obliged

thanking you
kumar abhishek
Re: difference between oracle 8i and 9i [message #33766 is a reply to message #33077] Mon, 01 November 2004 03:28 Go to previous messageGo to next message
ashok kumar sahu
Messages: 1
Registered: November 2004
Junior Member
Dear Sir/Madam ,

I want to know the difference between Oracle 8i and 9i.
what are the added features in oracle 9i which are not in oracle 8i?

thanks and regards
ashok sahu
Re: difference between oracle 8i and 9i [message #33780 is a reply to message #33077] Mon, 01 November 2004 20:13 Go to previous messageGo to next message
K.Sivakumar
Messages: 1
Registered: November 2004
Junior Member
Hi,
First point i would like to inform u people, don't talk interms of difference...talk interms of added features in 9i compare to 8i.
Anywya coming to point there r many feature sadded in 9i. ie according to DBA(Database administrator) side around 250 differences r there. Then according to developer side 27 diff r there. I can't write everything but i can say some important diff. ie as follows...
As per DBA side:
1.)SPfile concept. ie nothing but dynamic SGA, without disturbing the running instance in database init.ora some of the parameters can be changed.( do remember only some of the paramaters, that u check).
2.)In 8i people use to have only rollback segment which is giving ultimate porblem like running huge transactions by single user. So if Other people try to run any other even little amt of transactions they may get error. then the solution for that u have to go for mannul optimizing concept ie. compress the rollback segment. Instead of that in 9i ORACLE introduced Undo segment concept, this is having the features for auotmatic compressions for each segment ie. if the one undo segment reaches to its optimal size it goes for compression mode by automatically.
3.)Table partioning.
4.)Query Rewrite.
5.)Parallel Query Option.
6.)Tranportable Tablespaces, ie one database to another database we can transport the tablespace.
7.)Then very important is Oracle 9i supports multiple blocksize segment. ie the block can be increaing in the following way 2 power n ie its usually goes like 2k,4k,8k,16k....in 8i what ever we r creating the datablock size should be same for all the tablespaces.
8.)When we configuring for failover server from 9i we can make all of the copies of arichived log files to apply directly ie not only copying it'll apply also...ao that the downtime time will be very less. with in some seconds the other system will come up.
9.)On 8i there was only Snapshot concept but from 9i they introduced Materialized Veiws.
10.)Row chaning and Row migrations soultions.

Acording to developer side:
1.)Flashback Query
2.)Instead of decode also they introduced case.
3.)also they increased column of the table upto 270.

Then am sorry currenlt i don't remember...if any further clarification without any hestitate u can ask me. An dalso pls don't forget to ackonwledge this mail.
Ragards
Shiva
Re: difference between oracle 8i and 9i [message #33820 is a reply to message #33077] Wed, 03 November 2004 20:19 Go to previous messageGo to next message
Varsha medhane
Messages: 1
Registered: November 2004
Junior Member
Resp Sir,
I want to know difference between oracle 8i and 9i
pls let me know.
Thanks,
Varsha.
plz clear [message #33984 is a reply to message #33780] Mon, 15 November 2004 22:53 Go to previous messageGo to next message
pramod gupta
Messages: 1
Registered: November 2004
Junior Member
hi sir i read the diff. which r given by u.
I m sorry to say that i m not able to understand these
differences. Will u plz erase my doubts realted with oracle 8i & 9i.
I will wait for ur reply.

bye
Re: difference between oracle 8i and 9i [message #34283 is a reply to message #33766] Thu, 02 December 2004 18:31 Go to previous messageGo to next message
Gaurav
Messages: 20
Registered: February 2002
Junior Member
dear sir,
please send the diffrence between in the oraical 8i and 9i.
Re: difference between oracle 8i and 9i [message #224476 is a reply to message #33780] Wed, 14 March 2007 07:17 Go to previous messageGo to next message
sreddy4u
Messages: 7
Registered: February 2007
Junior Member
hi
you are saying that max columns in a table are 270 but i saw many tables in apps which have columns more than 270 eg.
table name 'MTL_SYSTEM_ITEMS_B'.(337 COLUMNS)
REGARDS
Re: difference between oracle 8i and 9i [message #224481 is a reply to message #224476] Wed, 14 March 2007 07:24 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Lets leave this thread to sleep peacefully shall we?
Previous Topic: ORACLE PROCEDURE ERROR
Next Topic: Does Oracle determine the index to use in a query based on whether update statistics has been run?
Goto Forum:
  


Current Time: Sun Dec 04 06:43:12 CST 2016

Total time taken to generate the page: 0.05276 seconds