Interested to Buy Any Domain ? << Click Here >> for more details...
difference between oracle 8i and oracle 9i
- 8 Answers
- 25413 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
In Oracle 8i we have no concept of partitioned tablespace
and nonpartitioned tablespace. Where as in 9i we have this
| Is This Answer Correct ? | 47 Yes | 8 No |
Answer / sujit pharande
In 9i merge , insert all, case is introduced .
SPfile in 9i which is not available in 8i version.
Oracle 9i added idea of somewhat pure m-commerce database
with lot of data warehouse feature .
In oracle 8i default tablespace is dictonary managed while
in 9i it is locally managed.
| Is This Answer Correct ? | 26 Yes | 5 No |
Answer / raquib
1. Oracle 9i run on browser but 8i doesn't
2. oracle 8i supports only 2 tier web applications but 9i
can support distirbuted applications.
| Is This Answer Correct ? | 21 Yes | 6 No |
Answer / navdeep kaur
1.multi table insert is possible.
2.u have tuning advisories with oracle 9i.
3.dynamic memory management is available with oracle 9i.
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / priya tyagi
1.In Oracle 8i defualt table space is dictionary managed
where as in 9i it is locally managed.
2.oracle 8i doesn't provide auto undo segment managment
where as 9i provides auto undo segment managment .
3.in 8i multi table insert is not possible where as it is
present in 9i.
4.in 8i Dynamic memory managment facility is not present
which is present in oracle 9i.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / montu
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.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / thiyagarajan
We cant rename a column in 8i.but in 9i we can do.
thse datatype of large object in oracle 8i is long but in
9i.it is LOB(large objects)
| Is This Answer Correct ? | 20 Yes | 16 No |
Write a query to find five highest salaries from EMP table. (there is a column SALARY)
24 Answers Cap Gemini, iNautix,
What's the difference between inner join and left join?
define primary key & secondary key?
Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
what is offset-fetch filter in tsql? : Transact sql
Explain the methods used to protect source code of pl/sql.
What is sql select statement?
What are different clauses used in sql?
What is ON DELETE CASCADE?
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
what is top in tsql? : Transact sql
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
