| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP : doubts regarding --- Tablespace ,Roll Segment , dif
Hi sangeetha,
Well, hope that u want to know all in big things in one struch ;-).
Ok, here are my answers to you.
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 empor 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:sangeeth_10_at_yahoo.com] Sent: Tuesday, November 27, 2001 5:30 PM To: Multiple recipients of list ORACLE-LSubject: 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
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 Wed Nov 28 2001 - 01:19:32 CST
 |
 |