oracle设置表空间自增

1 查询表空间是否设置了自增
SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE FROM dba_data_files where TABLESPACE_NAME=‘YSGY_TABLESPACE’;

2.如果AUTOEXTENSIBLE 为no,将FILE_NAME中的值替换下列sql中
ALTER DATABASE DATAFILE ‘D:\YSGY_TABLESPACE.DBF’ AUTOEXTEND ON;

ALTER DATABASE DATAFILE ‘D:\YSGY_TABLESPACE.DBF’ AUTOEXTEND ON NEXT 200M ;

ALTER DATABASE DATAFILE ‘D:\YSGY_TABLESPACE.DBF’ AUTOEXTEND ON NEXT 200M MAXSIZE 1024M;

SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE FROM dba_data_files  where  TABLESPACE_NAME='YSGY_TABLESPACE';

ALTER DATABASE DATAFILE 'D:\YSGY_TABLESPACE.DBF' AUTOEXTEND ON;
ALTER DATABASE DATAFILE 'D:\YSGY_TABLESPACE.DBF' AUTOEXTEND ON NEXT 200M ;
ALTER DATABASE DATAFILE 'D:\YSGY_TABLESPACE.DBF' AUTOEXTEND ON NEXT 200M MAXSIZE 1024M;