Re: Tiny datafile

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 -----
From: "Smith, Ron L." <rlsmith_at_kmg.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 19, 2000 2:50 PM 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 subscribing).
Received on Tue Sep 19 2000 - 14:16:18 CDT