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

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;

转载于:https://blog.51cto.com/junhai/2108449