oracle查询字符集语句分享

–DataFile脱机
ALTER TABLESPACE BSS11 OFFLINE      –作用对象：表空间BSS11的所有datafile
ALTER DATABASE ‘BSS_03.dbf’ OFFLINE  —作用对象：BSS_03.dbf，就一个datafile

–resize datafile
ALTER DATABASE DATAFILE ‘BSS_03.dbf’ RESIZE 500M;