Shulou(Shulou.com)06/01 Report--

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; query the user's default tablespace

Create tablespace EMERENCY datafile'+ DATA/orcl/datafile/EMERENCY.dbf' size 500m autoextend on

Alter user emergency default tablespace EMERENCY; modifies the user default tablespace

Users log in and query the tablespace where the table is located

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.