Re: Stupid Newbie Questions

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Thu, 16 Jul 1998 07:45:00 +0200
Message-ID: <35AD935C.360C3922@datenrevision.de>

Scott,
1. when I have to drop a database (that is: an instance), I just shut it down and remove all the files, except init.ora. After this, you can start recreating.

2. Oracle and Sybase are slightly different ;-) There is no concept of multiple databases on one "Server". The "instance" is an analogon to "database", and there is no level above it. So you have one database per instance. But you can create different "schemas" in the same instance/database. Each of these schemas is identified by prefixing the objects with the name of the schema owner.

Hope this helps
Rolf

Scott C. wrote:
>
> 1. How do I "drop" a database? I've just learned the database I created
> was using a page size of 2K. I want to recreate it using a page size of
> 32K.
>
> 2. Can I create more than 1 databaes per instance?
>
Received on Thu Jul 16 1998 - 00:45:00 CDT