Hi sangeetha,
Well, hope that u want to know all in big things in one struch ;-).
Ok, here are my answers to you.
1) If the tablespace constains objects, you should not drop it normally, however you can
do it by using the clause "include contents" in the drop tablespace command.
This case, the tablespace itself removed, but still the user will exists with the same tablespace.
But you cannt create any objects under that user, since tablespace is not available.
2) No. It's not necessary to create rollback segment( there is no such segment named Roll), every time you create
any tablespace. Usually, there should a one tablespace space for rollback segments, so whenever required you can
create it.
3) Myself known examples are,
a) External tables: you can query on a flat datafile from Oracle, if u created external tables.
b) Merge statment:, Suppose you want to insert into emp table using other table if the rows are not exists in emp
or else you want to update it. In such a case, the merge statement is useful for u.
More than this many new features are there.... so just gothrough the docs for it.
4) Oracle 7.3 was RDBMS, Oracle 8 was ORDBMS, Oracle8i is Internet based,(JAVA enables DB server), This is
very short difference between oracle versions, as remaing gothrough oracle docs.
HTH.
Rgds,
Nirmal.
-----Original Message-----
From: sangeetha [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 5:30 PM
To: Multiple recipients of list ORACLE-L
Subject: HELP : doubts regarding --- Tablespace ,Roll Segment , diff 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
__________________________________________________
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: sangeetha
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).
