Re: Stupid Newbie Questions

From: Winnie Liu <poohland_at_hotmail.com>
Date: Wed, 15 Jul 1998 22:50:40 -0700
Message-ID: <6ok43i$gug@sjx-ixn1.ix.netcom.com>

Scott C. wrote in message <6oj3t3$1s3$1_at_camel21.mindspring.com>...
>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.

You cannot "drop" a database. But you can recreate the database reusing all your current datafiles, controlfiles, redo log files. I forget about the correct syntax, it should be something like,

CREATE DATABASE REUSE DATAFILE... Check the doc from Oracle on the topic about creating a database.

>
>2. Can I create more than 1 databaes per instance?

An instance=a database. So there is no way you can create more than one database per instance because they are the same!!

Winnie Liu

>
>Scott Cairns
>sdcairns_at_mindspring.com
>
>"Damn it Jim, I'm a Sybase DBA not an Oracle guru!"
>
>
>
Received on Thu Jul 16 1998 - 00:50:40 CDT