RE: Tiny datafile

From: Miller, Bryan <MillerB_at_telergy.net>
Date: Tue, 19 Sep 2000 15:16:27 -0400
Message-Id: <10624.117384@fatcity.com>

If you drop the tablespace you can recreate it with the appropriate datafile.
Bryan M. Miller
Junior Oracle DBA
IT Operations
Telergy Inc.

Email: bmiller_at_telergy.net
Phone: (315)362-2642
Pager: (315)647-1908



		-----Original Message-----
		From:	Smith, Ron L. [mailto:rlsmith_at_kmg.com]
		Sent:	Tuesday, September 19, 2000 2:51 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Tiny datafile

		I accidentally created a datafile at 2 blocks instead of 2G.
I had to add
		another datafile after that to expand the tablespace.  I am
using 7.3.6.  Is
		there any way to utilize or get rid of the datafile other
than rebuilding
		the database?

		Ron Smith
		Database Administration
		rlsmith_at_kmg.com

		-- 
		Author: Smith, Ron L.
		  INET: rlsmith_at_kmg.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 Sep 19 2000 - 14:16:27 CDT