Re: HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent

1. Users are created in the database, not in a particular tablespace. If a tablespace is dropped dwith the "including contents" clause, then objects in the tablespace are also dropped. Dropping a tablespace NEVER drops users.
2. The function of rollback segments is described in the concepts manual(s).
3. New features of 9i are descibed here: http://download-east.oracle.com/otndoc/oracle9i/901_doc/server.901/a90 120/toc.htm and here: http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90 117/whatsnew.htm#968699
4. An overview of the new features in Oracle8i is at: http://technet.oracle.com/doc/server.815/a68020/ch2.htm#113030

-Don Granaman
[OraSaurus]

PS: This is a joke, right?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 27, 2001 8:30 AM between oracle 8i and 9i, and between oracle 8i and previous versions - urgent

> hi list,
> i enrolled in this list jus today and it was
> really nice to see the questions and the responses
> that were posted.....here i've got few doubts.....if
> possible plz do clear them as soon as possible, as
> comming nov 30th is my project presentation.
>
> 1)If a tablespace is deleted will the users and tables
> created in that tablespace get deleted?,if not in
> which tablespace will the users and tables get stored.
>
> 2)what is the function of Roll Segment?...is it
> necessary to create it every time we create
> tablespace?
>
> 3)plz do give me the exact difference between oracle8i
> and oracle9i,ie., what are the advancements in
> Oracle9i not present in oracle 8i.
>
> d) diff between oracle8i and its previous versions.
>
> plz do clear all or any of the above doubts.
> awaiting for all u're replies eagerly.
>
> regards
> sangeetha

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).