Here are some new features that may appeal to your developers.
- Several new built-in functions which are covered in the all covered in the
Oracle 9i SQL Reference Manual (Chapter 6).
- New SQL statements such as the MERGE statement, WITH clause
- New Join syntax (equi-join, left out join etc...)
- New case expression now available in SQL*Plus and PL/SQL
- UTL_FILE enhancements i.e. FCOPY, FREMOVE, FRENAME, FGETATTR
(Don't need to bounce the database to pick up a new entry added to
UTL_FILE_DIR any longer).
- New Oracle packages such as DBMS_METADATA, DBMS_FLASHBACK etc..
- Native compliation of PL/SQL (Convert PL/SQL code into C code... try this
with the Oracle's built-in packages!!!)
- Increased support for XML
- Enhanced Bulk Bind operation support
- Materialized view enhancements
- New datatypes such as TIMESTAMP
•
HTH
Roger
"JustAnotherDBA" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message
news:mYLma.11526$Xp1.10407_at_fe08.atl2.webusenet.com...
> Wanting to justify (to others-mostly manager/supervisors and developers) a
> migration this year of several Oracle 8.1.7 (and 8.1.6) databases to 9iR2
> (9.2.0.3 or latest). I plan on doing more research (reading the manuals
for
> one), but there is a meeting tomorrow that I know this will come up in :)
> and I need something quickly.
>
> Our client side is mostly W2K with 8.1.7 client installed.
>
> Our DB servers are all Solaris 8 with lots of memory, cpu, and disks.
>
> Also, as part of this upgrade I plan on moving to LMT and away from DMT
> (actually already doing this for new apps in 8.1.7 and 8.1.6).
>
> A couple of things come to mind for this justification, but I was
> wondering/hoping someone else could contribute to this:
> - 8.1.7 is being de-supported 12-31-2003 - I know we still get EAS and
just
> lose ECS for 3 more years, but this one would probably goes well with
> Mangers.
> - Lots of good things in 9i that I know as a DBA I like, some are noted in
> document on Metalink
>
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> ase_id=NOT&p_id=223724.1
>
> But, for developers nothing stands out to me as very significant/appealing
> to justify the migration to 9.2.0.3 (other than space management being
less
> work).
>
> Tanks!
> --
>
>
>
Received on Tue Apr 15 2003 - 03:30:46 CDT
