Re: Tablespace general question

From: Dante <dnotari_at_my-dejanews.com>
Date: Tue, 18 May 1999 08:12:46 GMT
Message-ID: <7hr7dv$s2k$1@nnrp1.deja.com>

Edmond,
I strobgly recommend you have
a look at the Oracle Concepts manual which comes with your Server.

There all your questions are answered.

Regards
Dante

In article <7hpo96$rsn$1_at_nnrp1.deja.com>, poonek_at_my-dejanews.com wrote:
> 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.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 03:12:46 CDT