Re: Newbie question. Help!

On Sun, 1 Aug 1999 22:56:09 +1000, "Hartono Nugroho" <hanugroNOSPAM_at_ibm.net> wrote:

>Hi all,
>
>I am a university student learning Oracle using Oracle 8i. I am used to
>using PC databases such as Access and become confused with Oracle. I have
>few questions regarding Oracle database system.
>
>1. How can I specify a table that I created to go to specific database? I
>got few databases in the computer. I am usually logged in using
>Internal/Oracle to create a table. Yet I don't have any idea which database
>that I actually used at that time.
>
>2. Is there anyway to erase database and service completely from my system?
>I deleted a databases recently and would like to create a new one with the
>same SID, however Oracle won't let me even though I already deleted the
>database and the service.
>
>
>Thanks in advance for all your help.
>Hartono
>
>

Hi Hartono

The confusion is clear from your questions, and you seem already to have created some havoc. I will try to give the broad picture at the same time.
In Access you really have only one database schema. Who the owner is is relatively unimportant. Oracle implemented the logical-conceptual-physical model. You have multiple schemas/table owners, which you could consider as a virtual database, multiple virtual/logical databases reside in one physical database. So you don't create a new physical database, you create a new user.

The picture is
service <-> instance (on the same level) -> manages 1 physical database -> has 1 or multiple schemas.

As to your first question:
You need to create your own user. The user internal is nothing more than sys, the owner of the physical database and the owner of the data dictionary. You should NEVER create tables in the SYS schema.

2 This is platform specific, and you didn't specify which platform you are using.
I assume NT.
On NT there is an Oradim<xx> utility, for this version probably Oradim80.
oradim -delete in GUI mode will destroy the complete database including files. It destroys both the service and the instance. In a dos box it will remove the service only. oradim -new creates a new database. Note: your startup file, init<sid>.ora should already be present, and the controlfile parameter in this file should have the correct values. The init<sid>.ora file can be found in
%ORACLE_HOME%\database\init<sid>.ora.
The controlfile usually also has the <sid> designator in it.

All this info is well documented in getting started guides. If you don't have it, subscribe (free) to technet.oracle.com and you will be able to read docs for all platforms.

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Aug 01 1999 - 09:01:15 CDT