開發(fā)把表空間建在磁盤組上了

select name,bytes/1024/1024/1024 from v$datafile;
select total_mb/1024,usable_file_mb/1024 from v$asmdiskgroup;
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;