Message-Id: <10624.117385@fatcity.com> From: "Ron Rogers" Date: Tue, 19 Sep 2000 15:24:10 -0400 Subject: Re: Tiny datafile You can RESIZE the datafile to a size you like using the: Alter database datafile 'filename' RESIZE nnn M/K; ROR =AA=BF=AA >>> rlsmith@kmg.com 09/19/00 02:50PM >>> 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@kmg.com=20 --=20 Author: Smith, Ron L. INET: rlsmith@kmg.com=20 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@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).