DIFFERENCE BETWEEN ORACLE 8i & ORACLE 9i

1 New Member

COULD YOU EXPLAIN ME WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ............... ............

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU....... ......

Oct 26 '06 #1

Subscribe Reply

13795

pks00

280

Recognized Expert Contributor

COULD YOU EXPLAIN ME WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ............... ............

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU....... ......

Oracle 8i and 9i are different versions of the database. Oracle9i is a newer release to Oracle8i, it will have more enhancements, fixes etc. New features are available to both developers and administrators.

With Oracle each new version contains the same functionality as the previous version. So Oracle 9i is backwards compatible with 8i. Oracle 9i does many things differently internally so they are not exactly the same database engine. And Oracle 9i has a host of new features designed to make the database more stable, easier to manage and increase functionality. There are so many new features that Oracle Corp. provides a complete manual listing these new feature. The Oracle 9i New Features manual can be found on Oracle's Technet site at if you are interested. You will need to register for a free account if you want to view documentation on that site.

DBMS/RDMBS -
read this http://www.faqfarm.com/Q/What_is_the_dif ference_between _DBMS_and_RDBMS

Oct 29 '06 #2

23prabu

New Member

WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ............... ............

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU....... .....

Mar 17 '08 #3

amitpatel66

2,367

Recognized Expert Top Contributor

WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ............... ............

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU....... .....

Your Question is very theoritical and is out of scope of this forum to answer. You can go through some good oracle book or google out some materials for theoritical questions.

Mar 17 '08 #4

smruti

New Member

WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ............... ............

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU....... .....

oracle8i
1) only rbo(rule base optimizer)
2)no merge statement available
3)no full outer join available
4)no timestamp datatype available
5)sql and pl/sql engine are different engine.

Oracle9i
1)both RBO and CBO(cost base optimizer)
2)MERGE is there.
3)FULL OUTER JOIN is there
4)TIMESTAMP is there
5)SQL AND PL/SQL ENGINE IS INTEGRATED INTO SINGLE ENGINE

Dbms
1)In dbms relationship between tables maintained programatically
2)not secure
3)doesn't support client server architechure.
4)satishfy 5/6 codd's rule.

RDBMS
1)In RDBMS relationship between tables maintained at table creation
2)Secure becoz we can login into a OS promth.
3)Support client server architechre
4)Satishfy 9/10 codd's rule.

Mar 18 '08 #5

Similar topics

8460

Experience with PHP & Oracle 9.2.0/OCI8

by: Ollivier Robert | last post by:

Hello, I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9 system. The link succeeds but everytime I try to run php, I get a SEGV from inside the libcnltsh.so library. 354 roberto@ausone:Build/php-4.3.2> ldd /opt/php4/bin/php libsablot.so.0 => /usr/local/lib/libsablot.so.0 libstdc++.so.5 => /usr/local/lib/libstdc++.so.5 libm.so.1 => /usr/lib/libm.so.1

PHP

3032

Image and text: howto see the difference

by: Mattias Campe | last post by:

Hi, Depending on if I get an image or a text of a certain URL, I want to do something different. I don't know in advance whether I'll get an image or a text. This is a URL that returns an image: http://indicator.amessage.info/indicator.php?param1=cobnet%40jabber.org&param2=bounce&param3=http%3A%2F%2Fstudent.ugent.be%2Fastrid%2Fpics%2Fjabber%2F&param4=.png

PHP

20197

Oracle client install on AIX 5.1 -- NetAssistant & SQLPLUS do not run

by: Rick | last post by:

I am installing Oracle 9i client runtime on AIX 5.1-003. The installation completes successfully, but neither the Net Configuration Assistant or SQLPLUS will run. I get the following error when trying to run netca: Error loading native library: libnjni9.so. java.lang.UnsatisfiedLinkError: jniGetOracleHome at oracle.net.common.NetGetEnv.getOracleHome(NetGetEnv.java) at oracle.net.ca.CmdlineArgs.setOraArgs(CmdlineArgs.java)

Oracle Database

5230

Oracle & WinXP Pro

by: Jake McDermott | last post by:

We have a few developers that use Oracle 9i (9.2.0.4.0) on their personal workstations for testing purposes. Recently, weve made the decision to upgrade them to WinXP so that they are able to use some other functionalities of the OS, but we are running into a totally odd problem with Oracle. It seems that, Installing Oracle runs just fine, and our ant scripts to build the database work well...but when we reboot the computer, the database...

Oracle Database

5771

SOS! ORA-03114: not connected to ORACLE && MS's Bug??

by: Ê¹ÃûÑï | last post by:

ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access class. using System.Data.OracleClient;

C# / C Sharp

1831

difference /u and &#

by: Bart | last post by:

Hi, I receive an utf8 character from a database, like 田 (Japanese Character, style: &#XXXXX). How can I visualize the Japanese character on my application? I have found the class System.Text.Encoding, but the input looks like \uXXXX. I don't know how to do. Thank you,

C# / C Sharp

3013

Oracle 9i & Windows Service Program Error

by: MAL | last post by:

Hello, I have 2 classes that work great as a windows app to retrieve and process data from an Oracle9i db. When I implement them in a Service program running as Local System, it fails on the .open. I am using OLEDB for Oracle 9.2.0.4. I have verified the Oracle Client install, Local Sys' path variable, and followed MSKB article 259959(Debugging connectivity issues w/ Oracle). Here is the error:

Visual Basic .NET

4228

Convert MS Access DB (FE&BE) to Oracle

by: egoldthwait | last post by:

I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with this. Also - the citrix folks do not want us to keep the FE in Access as the queries and other activities consume a lot of power. The users will be in 3 different offices across the globe all accessing the 1 Oracle DB in Citrix. Does anyone have...

Microsoft Access / VBA

1913

difference between installing oracle 10g R2 software on linux & solaris

by: nalinicisf | last post by:

hello , this is nalini could you please tell me the difference between the installation method of oracle 10g R2 software on linux and solaris. give me the guidelines.................. thank you

Oracle Database

8428

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8337

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8748

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8531

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8628

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7359

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4175

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4335

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2754

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp