You can issue the command:
Alter database datafile '/u001/oradata/mydatafile01.dbf' resize 1MB
Some caveats:
1. BACK UP THE DATABASE BEFORE YOU DO THIS
2. The space you are dropping must be contiguous free space at the
end of the datafile. Check dba_free_space to see how much you can
decrease and if colaesce might help you.
3. If you are using multiple dbwriters, you might have problems
accessing a resized datafile. It's an Oracle bug I saw in one of my v7x
databases (that I haven't had a problem with in 8i). You'll have
to shiutdown and restart.
4. BACK UP THE DATABASE AFTER YOU DO THIS
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Djaroud Salim
<SDJaroud@france-se To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
cours.com> cc:
Sent by: Subject: resize in 7.3.4 urgent
[EMAIL PROTECTED]
07/17/2001 12:05 PM
Please respond to
ORACLE-L
hi,
i want if any body try to resize a datafile to a lower value.
i'm on oracle 7.3.4 on hpunix 10.0
thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djaroud Salim
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).