You can also resize the datafile to 2G ..
- Ruth Gramolini <rgramolini_at_tax.state.vt.us> 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"
> <ORACLE-L_at_fatcity.com>
> 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_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).
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_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_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).
Ashish
Toronto, Canada
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Tue Sep 19 2000 - 14:48:11 CDT