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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
