Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

resize datafile

user8838095Aug 10 2020 — edited Aug 17 2020

Hi,

DB - 12.1.0.2.0

OS - Oracle Linux Server 6.10

I added the datafile in Tablespace as command

ALTER TABLESPACE "ORCL_TABLESPACE" ADD DATAFILE f:....../orcl01.dbf' SIZE 5000M REUSE AUTOEXTEND ON NEXT 30M MAXSIZE 5000M;

I want to reduce the initial level of 5000M into 40M or 50M, by which command i resize it ?

Thanks.

This post has been answered by Adityanath Dewoolkar on Aug 10 2020

Jump to Answer

Added on Aug 10 2020

#general-database-discussions

6 comments

698 views