Database

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 :)

About these ads

Discussion

No comments yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Archives

Twitter Updates

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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: