select 'ALTER DATABASE DATAFILE '||''''|| file_name ||''''||' AUTOEXTEND OFF;' FROM DBA_DATA_FILES WHERE tablespace_name='APPS_TS_MEDIA';

ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA01.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA02.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA03.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA04.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA05.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA06.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA07.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA08.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA09.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA10.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA11.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA12.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA13.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA14.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA15.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA16.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA17.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA18.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA19.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA20.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA21.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA22.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA23.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA24.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA25.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA26.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA27.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA28.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA29.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA30.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA31.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA32.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA33.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA34.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA35.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA36.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA37.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA38.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA39.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA40.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA41.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA42.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA43.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA44.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA45.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA46.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA47.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA48.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA49.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA50.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA51.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA52.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA53.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA54.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA55.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA56.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA57.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA58.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA59.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA60.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA61.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA62.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA63.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA64.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA65.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA66.dbf' AUTOEXTEND OFF;