RE: DROP DATABASE

Yes, in case you do a full db export. No in case of owner/table options

hth
deepAk

-----Original Message-----
From: Glenn Travis [mailto:Glenn.Travis_at_wcom.com] Sent: Tuesday, August 15, 2000 3:48 PM
To: Multiple recipients of list ORACLE-L Subject: RE: DROP DATABASE

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