How do I upgrade from Oracle 9i to 11g?
How do I upgrade from Oracle 9i to 11g?
Upgrade from 9i to 11g
- The following is a real scenario for upgrading a 9.2.0.8 DB to 11.2.0.1.0 version on Redhat 4.7 in 28 Step.
- Required packges for installing 11g software: This for RHCL 4.7.
- Note ID: 429825.1.
- ———-
- Step 3: Save a script for Deprecated CONNECT Role:
- ———-
- Step 5: Upgrade the TIMEZONE version.
What is the difference between 9i and 10g in Oracle?
Oracle 9i. Oracle 10g has higher system requirements than Oracle 9i. Both versions have excellent features. The main difference between the two is that Oracle 10g is a higher version than Oracle 9i and has many added features that enhance the features of Oracle 9i while some old features may have been abandoned.
What is 9i in Oracle?
Oracle 9i is a version of the Oracle Database. The i stands for “Internet” to indicate that 9i is “Internet ready”.
What are the features of Oracle 9i?
SQL New Features In Oracle 9i
- Explicitly Named Indexes On Keys.
- Share Locks On Unindexed FKs.
- PK Lookup During FK Insertion.
- View Constraints.
- Function Based Index Enhancements.
- MERGE Statement.
- Multitable Inserts.
- External Tables.
What is the use of Oracle 10g?
Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers.
Which is best Oracle 10g or 11g?
Compared with Oracle 10g, the later version of Oracle 11g offers more simplified, automated, and advanced memory management tools and features. The latter is equipped with better abilities to diagnose faults via inbuilt infrastructure. In Oracle 11g, technical documentation is better than that available in 10g.
What is Oracle 8i?
Oracle 8i is a version of the Oracle Database. The i stands for “Internet” to indicate that 8i is “Internet ready”. Also see Oracle 9i, Oracle 10g and Oracle 11g.