If we want to resize the existing data file. We must use Alter database data file resize command.
Before doing resize the data file in oracle database, we will
have to check the existing data file size.
SQL>select file_name,bytes/1024/1024 SIZE_IN_MB from
dba_data_files where tablespace_name=’XXCUSTOM’;
Resize the oracle database data file using below command.
SQL>alter database
datafile ‘/path/filename.dbf’ resize 6g;
For additional information on Administering Database Size.Please check. 👉alter tablespace add datafile.
No comments:
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.