Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DROP DATABASE

RE: DROP DATABASE

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Wed, 16 Aug 2000 02:54:04 GMT
Message-Id: <10590.114672@fatcity.com>


if you are importing a full db export, and the tablespace does not exist.... yes, it will.

I used to do a full db export and then import on another server to create a contingency databaase.

>From: Glenn Travis <Glenn.Travis_at_wcom.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: DROP DATABASE
>Date: Tue, 15 Aug 2000 14:47:54 -0800
>
>Does oracle create tablespaces on import?
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel
> > Carmichael
> > Sent: Tuesday, August 15, 2000 4:31 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: 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).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
> >
>
>--
>Author: Glenn Travis
> INET: Glenn.Travis_at_wcom.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).


Received on Tue Aug 15 2000 - 21:54:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US