| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DROP DATABASE
The only way to rebuild the database with the new init.ora size is to do a
full database export, shutdown the database normal, do a cold backup (just
in case), delete the datafiles (well, if you are recreating the same size
and number etc etc you don't have to do this), create a new minimal database
(system and temp and rbs) and then do a full database import. Oracle will
create the tablespaces, users etc etc etc during the full import.
Note that some of the other init.ora parameters, which depend on the db_block_size will need to be changed.
>From: "Eliane Bischoff Trauer" <eliane_at_hotpop.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: DROP DATABASE
>Date: Tue, 15 Aug 2000 11:31:16 -0800
>
>How can I drop an entire database?
>
>I intend to change the db_block_size init.ora parameter. In order to have
>it
>changed, I need to rebuild the entire database. I was planning on dropping
>each tablespace but I am not sure how to do it for the RBS tablespace in an
>open database, for example.
>TIA,
>
> Eliane
>
>
>--
>Author: Eliane Bischoff Trauer
> INET: eliane_at_hotpop.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
 |
 |