To find dba data files which are autoextensible:
$select FILE_NAME, AUTOEXTENSIBLE from dba_data_files where FILE_NAME like '%sapdata2%' and AUTOEXTENSIBLE='YES';
To turn off the auto extend for a file :
$ALTER DATABASE DATAFILE '/oracle/BIP/sapdata2/sr3usr_3/sr3usr.data3' autoextend off;
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about Selenium.
selenium Training in Chennai
Post a Comment