Message-Id: <10624.117389@fatcity.com> From: Ashish Shah Date: Tue, 19 Sep 2000 12:48:11 -0700 (PDT) Subject: Re: Tiny datafile You can also resize the datafile to 2G .. --- Ruth Gramolini wrote: > If there are no objects in the datafile you can > take it offline and delete > it. If there are objects you can export them, drop > them, and then take the > datafile offline and delete it. You can import the > objects back into the > larger datafile. > > HTH, > Ruth > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > > Sent: Tuesday, September 19, 2000 2:50 PM > > > > 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 > > > > -- > > Author: Smith, Ron L. > > INET: rlsmith@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@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: Ruth Gramolini > INET: rgramolini@tax.state.vt.us > > 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). ===== Ashish Toronto, Canada __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger.