There r so many many many ... differencies between 8i and 9i.
- You can change SGA whenever you want!
- Multiple DB block size support.
- Log miner enhancement. DDL statement supported.
- Automated management of rollback segments.
- OMF. Remove datafile automatically when you drop tablespace.
- Locally managed datafile default
- Enhancement of standby DB. Automatically transfer the online redo log
files.
- You can see execution plan any time.
- ANSI type sql support.
- Flash back query support. (ex: You can query data before 5 minutes
whether you delete and commit.)
- Enhancement of OPS => RAC(Real Application Cluster) : Cache Fusion full
support
- DML enhancement. One SQL statement support insert and update.
- etc...
Steve <schen88_98_at_yahoo.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:d16fecf0.0108171216.5cce20_at_posting.google.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> Does anyone know the difference of Oracle 8i and 9i?
>
> Thanks,
>
> Steve
Received on Sat Aug 18 2001 - 10:02:05 CDT