Switching a datafile from AUTOEXTEND ON to OFF
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Switching a datafile from AUTOEXTEND ON to OFF

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    Switching a datafile from AUTOEXTEND ON to OFF

    Can this be done?
    I've RTFM and can't find a suitable ALTER TABLESPACE or similar syntax.

    (Ora8.1.5)

  2. #2
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323

    Re: Switching a datafile from AUTOEXTEND ON to OFF

    Originally posted by JMac
    Can this be done?
    I've RTFM and can't find a suitable ALTER TABLESPACE or similar syntax.

    (Ora8.1.5)
    Try

    alter database datafile 'path/xx.dbf' autoextend off;

    hope this helps
    Nagesh

  3. #3
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133

    Re: Switching a datafile from AUTOEXTEND ON to OFF

    Originally posted by JMac
    Can this be done?
    I've RTFM and can't find a suitable ALTER TABLESPACE or similar syntax.

    (Ora8.1.5)
    You have to RTFM again
    alter database datafile '/???/???/datafile.dbf' autoextend off ;
    Giani

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Well there's consistenecy for you:

    To create: ALTER TABLESPACE

    To amend: ALTER DATABASE

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width