| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_at_kmg.com=20
--=20
Author: Smith, Ron L.
INET: rlsmith_at_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_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:24:10 CDT
 |
 |