-
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)
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|