Can this be done?
I've RTFM and can't find a suitable ALTER TABLESPACE or similar syntax.
(Ora8.1.5)
Printable View
Can this be done?
I've RTFM and can't find a suitable ALTER TABLESPACE or similar syntax.
(Ora8.1.5)
TryQuote:
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)
alter database datafile 'path/xx.dbf' autoextend off;
hope this helps
You have to RTFM again:DQuote:
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)
alter database datafile '/???/???/datafile.dbf' autoextend off ;
Well there's consistenecy for you:
To create: ALTER TABLESPACE
To amend: ALTER DATABASE
Thanks :o