Re: Tablespace general question

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Mon, 17 May 1999 16:46:21 -0400
Message-ID: <7hpv2a$95m$1@autumn.news.rcn.net>

Hi,

    No you shouldn't delete these tablespaces since Oracle needs them.

    The only thing you should create as SYS are user accounts with DBA privileges. Then you should use a DBA account to create user accounts that don't have DBA privileges. A good rule of thumb is to use the least privileged account possible to perform work in the database. This will limit the amount of damage you can do if you mess up.

    What you are asking about are the messages returned by the SVRMGR (the program that starts up the database, not the commands that you issue.)

    The three messages are indicators of the progress of the database startup.

        Instance started means that the Oracle program is now running
        Database mounted means that Oracle was able to bring the database
online
        Database open means that Oracle has done its housekeeping and has

made the database available to all of your users.

regards

Jerry Gitomer

---

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:46:21 CDT