Alter Datafile from autoextend on to off

Sometimes you want to disable automatic extend on your datafile and extend its size. You may use this script

For example :

Datafile : your_dbfile.dbf size 2G autoextend on

You want to change it into 5G and disable the autoextend

Here we are

alter database datafile 'your_dbfile.dbf ' resize 5G
alter database datafile 'your_dbfile.dbf ' autoextend off

Just it 🙂



No comments yet.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


Twitter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

%d bloggers like this: