Wednesday, August 12, 2015

Auto extend off all datafiles in database at once

select 'ALTER database datafile '''||FILE_NAME||''' autoextend off;'  from dba_data_files where tablespace_name not in ('SYSTEM','SYSAUX','UNDOTBS1','USERS','UNDOTBS2') and AUTOEXTENSIBLE='YES';

run the output :)

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...