Re: oracle 10i

Bahar

This is not Oracle 10i but 10G. It is new Oracle Release which is going to be release during the Oracle Openworld Next Week. So be ready for adventure thru bug again and have fun (????) in reading the Manual again. I came to know some very good features but it is still not finalized [ I can't say until I really use them ] and below are 10 points for new 10G/10i for your reference

Multiple default Temporarary Tablespace support is going to be available to meet your SQL manipulation
You can rename Tablespace like Tables
Transportable tablepsace can be utilized across Platforms using RMAN Auxilary SYSTEM Tablespace named SYSAUX is created with Database so as to take care of space issue for your dictionary for special Oracle features. e.g Oracle streams data dictionary is created in SYSAUX instead of default SYSTEM tablespace and so on
You can now create big single file Tablespace as support is extended to some exabytes [8 exabytes (8 million terabytes)] Some extra fast recovery by providing more flexibility to FLASHBACK command as now you might be able to use FLASHBACK DATABASE to bring the database to some prior point in time. There are lots more in FLASHBACK like FLASHBACK TABLE, restore accidently dropped Oracle tables and some new views
More Dynamic SGAcapabilities by including JAVA_POOL_SIZE as well as some new parameter like STREAMS_POOL_SIZE along with new dictionary views for easy information
Depreciated MAXTRANS, ROLLBACK SEGMENT [ including Manual UNDO segment management]
You can create the Reovery area in your database to manage files realted to back and recovery
SOme Destructive command like DROP DATABASE command which can freed you from DBA responsibility by removing all control files as well as Data files.  

Hope full will learn more in the Openworld espcially how Oracle points to Grid computing
Indy Johal
Manager, Database Administration
PR Newswire
indy_johal_at_prnewswire.com
http://www.prnewswire.com

(201) 946-5687 [W]
(201) 400-3960 [M]

"We tell your story to the world."

<A.Bahar_at_billing-components.com>
Sent by: ml-errors_at_fatcity.com
09/04/03 10:54 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        oracle 10i

what is this ? oracle 10i !

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <A.Bahar_at_billing-components.com
  INET: A.Bahar_at_billing-components.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Indy Johal
  INET: Indy.Johal_at_prnewswire.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).