开发把表空间建在磁盘组上了

原创

山炮运维 2018-04-27 11:01:42 博主文章分类：Oracle ©著作权

©著作权归作者所有：来自51CTO博客作者山炮运维的原创作品，请联系作者获取转载授权，否则将追究法律责任

select name,bytes/1024/1024/1024 from v$datafile; select total_mb/1024,usable_file_mb/1024 from v$asm_diskgroup; alter add tablespace EMERENCY tbs_ create tablespace EMERENCY datafile='+DATA/orcl/datafile/EMERENCY.dbf'

select * from user_tables;

select * from user_tables where USERNAME ='EMERGENCY'; select username,default_tablespace from dba_users ; 查询用户默认的表空间 create tablespace EMERENCY datafile '+DATA/orcl/datafile/EMERENCY.dbf' size 500m autoextend on; alter user emergency default tablespace EMERENCY; 修改用户默认表空间

用户登入，查询表所在的表空间 select table_name,tablespace_name from user_tables;

alter table LOG_OPERATE move tablespace EMERENCY; alter table LOG_OPERATE_DETAIL move tablespace EMERENCY; alter table LOG_SIGNALING_COLLECT move tablespace EMERENCY; alter table SYS_AREA move tablespace EMERENCY; alter table SYS_ATTCHMENT move tablespace EMERENCY; alter table SYS_DEPT move tablespace EMERENCY; alter table SYS_FUNC move tablespace EMERENCY; alter table SYS_ROLE move tablespace EMERENCY; alter table SYS_ROLE_FUNC move tablespace EMERENCY; alter table C_IMSI move tablespace EMERENCY; alter table C_REAL_DATA move tablespace EMERENCY; alter table C_SIGNALLING_HISTORY move tablespace EMERENCY; alter table C_SIGNALLING_REAL move tablespace EMERENCY; alter table C_TIME_COUNT_HISTORY move tablespace EMERENCY; alter table HJ_GROUP move tablespace EMERENCY; alter table HJ_REGION move tablespace EMERENCY; alter table HJ_TYPE move tablespace EMERENCY; alter table LOG_ALARM move tablespace EMERENCY; alter table LOG_LOGIN move tablespace EMERENCY; alter table LOG_MAIL_NOTICE move tablespace EMERENCY; alter table LOG_NE_COLLECT move tablespace EMERENCY;

alter table LOG_NE_COLLECT_DETAIL move tablespace EMERENCY; alter table SYS_USER move tablespace EMERENCY; alter table SYS_USER_ROLE move tablespace EMERENCY; alter table T_AREA_NET_NEXUS move tablespace EMERENCY; alter table T_LIVE_INFO move tablespace EMERENCY; alter table T_NET_ELEMENT_INFO move tablespace EMERENCY; alter table T_SET_AREA_INFO move tablespace EMERENCY; alter table T_USER_POSITION_INFO move tablespace EMERENCY; alter table LOG_NE_COLLECT_DETAIL3 move tablespace EMERENCY; alter table TEST002 move tablespace EMERENCY; alter table C_TIME_COUNT move tablespace EMERENCY;