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;