Re: Tablespace general question

Hi Edmond,

As to your questions
1 From your questions it looks like you are a newbie. I strongly advise you: leave them alone! SYSTEM contains the datadictionary, ROLLBACK_DATA the rollback segments, TEMPORARY_DATA the temporary segments, USER_DATA the endusers data. What DRSYS is I don't know, this is a change from Oracle 7, but there are probably good reasons for it. 2 It is doesn't make any difference as they are owned by SYS anyway. Main difference between SYS and internal; You can connect as internal always, as the internal privileges are not checked against the datadictionary. You don't need to have the database open to connect as internal. 3 instance started is equivalent to startup nomount, only the background processes are started

   database mounted is equivalent to startup mount. The database is not available to end-users. Maybe used to rename datafiles and recover the database.

The following words may sound a bit harsh. I strongly advise you to get training or at least to read the Oracle Server Concepts Manual.
This newsgroup is a place to help each other out, NOT to provide a complete FOC Oracle Course.
You should at least try to read the documentation that comes with the product. If you don't have docs get a free account at http://technet.oracle.com and read them from there.

Best regards,
Sybrand Bakker, Oracle DBA

poonek_at_my-dejanews.com wrote in message <7hpo96$rsn$1_at_nnrp1.deja.com>...
>Hi
>
>After I have install Oracle with the database starter, I find that
>there is several tablespace, DRSYS, ROLLBACK_DATA, SYSTEM,
>TEMPORARY_DATA, USER_DATA. What are they? Can I delete them?
>
>If I (my own Oracle DBA account) log in the SQL Plus and create a table
>or tablespace, does it make any differecne if I log in as INTERNAL or
>SYSTEM to create them? If so, what is the difference?
>
>What is the difference if I select "instance started", "database
>mounted", and "database open" in the Instance Manager?
>
>Thanks
>
>Edmond
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Mon May 17 1999 - 15:45:28 CDT