Welcome to Dream.In.Code
Getting Help is Easy!

Join 136,508 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,718 people online right now. Registration is fast and FREE... Join Now!




Difference between 8i and 10g oracle

 
Reply to this topicStart new topic

Difference between 8i and 10g oracle, What is the difference between 8i and 10g oracle?

Ish.aneja
14 Aug, 2008 - 08:40 AM
Post #1

New D.I.C Head
*

Joined: 24 Jun, 2008
Posts: 3

Need to just install on my PC so i am asking difference in both
User is offlineProfile CardPM
+Quote Post

jjsaw5
RE: Difference Between 8i And 10g Oracle
14 Aug, 2008 - 11:37 AM
Post #2

I must break you
Group Icon

Joined: 4 Jan, 2008
Posts: 1,404



Thanked: 6 times
Dream Kudos: 125
Expert In: HTML, CSS, Database,

My Contributions
Google is your friend. Use it.

I took your thread title punched it into google...and what do you know the 1st thing that game up was this. Someone else asked the exact same question that you did.


This link may not answer you question completely, but now you can see that if you do a littl research you can usually find the answer.

This post has been edited by jjsaw5: 14 Aug, 2008 - 11:39 AM
User is offlineProfile CardPM
+Quote Post

Trogdor
RE: Difference Between 8i And 10g Oracle
15 Aug, 2008 - 12:50 AM
Post #3

D.I.C Addict
Group Icon

Joined: 6 Oct, 2006
Posts: 523



Thanked: 3 times
Dream Kudos: 125
My Contributions
Do you realize that you are comparing a database from the year 1997 (8i) with a version from 2005 (10g) ?
Timewaste.
User is offlineProfile CardPM
+Quote Post

Ish.aneja
RE: Difference Between 8i And 10g Oracle
12 Oct, 2008 - 08:07 AM
Post #4

New D.I.C Head
*

Joined: 24 Jun, 2008
Posts: 3

QUOTE(Trogdor @ 15 Aug, 2008 - 01:50 AM) *

Do you realize that you are comparing a database from the year 1997 (8i) with a version from 2005 (10g) ?
Timewaste.



I know what i m asking, if you don't want to provide proper solution, why are you trying discourage someone. I really appreciate to you for your time.

Regards,
Ish Aneja

Question is the key for getting more knowledge from depth!

QUOTE(jjsaw5 @ 14 Aug, 2008 - 12:37 PM) *

Google is your friend. Use it.

I took your thread title punched it into google...and what do you know the 1st thing that game up was this. Someone else asked the exact same question that you did.


This link may not answer you question completely, but now you can see that if you do a littl research you can usually find the answer.



Thanks, for giving your time
User is offlineProfile CardPM
+Quote Post

Trogdor
RE: Difference Between 8i And 10g Oracle
13 Oct, 2008 - 05:14 AM
Post #5

D.I.C Addict
Group Icon

Joined: 6 Oct, 2006
Posts: 523



Thanked: 3 times
Dream Kudos: 125
My Contributions
The difference is simple: 8 is very old, 10 is less old.
There should be no reason to install sw as old as oracle 8 unless you need to reproduce something or are working on legacy stuff.
If you are installing a new environment, use new software.
User is offlineProfile CardPM
+Quote Post

baavgai
RE: Difference Between 8i And 10g Oracle
13 Oct, 2008 - 06:52 AM
Post #6

Dreaming Coder
Group Icon

Joined: 16 Oct, 2007
Posts: 2,031



Thanked: 105 times
Dream Kudos: 475
Expert In: C, C++, Java, C#, ASP.NET, PHP, Perl, Python, Oracle, SQL Server, MySql, HTML, JavaScript, Lua

My Contributions
I still have a production system on 8i. If the vendor doesn't want to move, or doesn't support what you need on a new version, you're stuck.

Basically, lots of crap added. 8i stuff should run fine on 10g, but if you used some word that's now reserved you can get bitten. Micro managing DBAs can still play, but there's more automated space allocation if you really don't care. Local spaces, that kind of thing.

Also, RMAN moves from "use it if you like" to mandatory. No more just treating archive logs as files. You have to tell the database or else. I'd read up on RMAN, that's the biggest gotcha I've seen and there's no avoiding it.

User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/2/08 08:44PM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month