RE: DROP DATABASE

From: Carle, William T (Bill), NBSO <wcarle_at_att.com>
Date: Tue, 15 Aug 2000 13:57:19 -0500
Message-Id: <10590.114644@fatcity.com>

Hi,

    You can drop the RBS tablespace. I assume since you're dropping the whole database, you won't have anyone accessing it anyway. If you want to save the data, just export all the tables and you can re-import them after you build the new database. To get rid of the database, just drop all the tablespaces, shut the database down, and delete all the files. Then rebuild from scratch and import your data.

Bill

		-----Original Message-----
		From:	Eliane Bischoff Trauer [mailto:eliane_at_hotpop.com]
		Sent:	Tuesday, August 15, 2000 2:31 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	DROP DATABASE 

		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

Received on Tue Aug 15 2000 - 13:57:19 CDT