RE: HELP : doubts regarding --- Tablespace ,Roll Segment , dif

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Tue, 27 Nov 2001 08:45:42 -0800
Message-ID: <F001.003CDB84.20011127074522@fatcity.com>

sangeetha,

When a tablespace is deleted, the users do not get dropped. Users would still be present. However, the tables created on the tablespace would be dropped. Users and their details are maintained in Oracle dictionary. If you have DBA permissions on your database, check the view, dba_users. You would see all the users.
A rollback segment stores any data that is changed in the database. But there are many ramifications for a rollback segment. Read Oracle concepts manual for a complete understanding of rollback segments.
There are many differences between Oracle 8i and Oracle 9i. Listing them here would be very lengthy. You could create a user account in http://otn.oracle.com/ . It is free. There go to this link -- http://otn.oracle.com/products/oracle9i/content.html . In this you would see a title - Oracle 9i features.

Rao

-----Original Message-----
Sent: Tuesday, November 27, 2001 9:30 AM To: Multiple recipients of list ORACLE-L 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: Rao, Maheswara
INET: Maheswara.Rao_at_Sungardp3.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). Received on Tue Nov 27 2001 - 10:45:42 CST