摘要: 计算schema在原库的空间大小select SEGMENT_TYPE,sum(a.bytes)/1024/1024/1024 from USER_EXTENTS a group by A.SEGMENT_TYPE;建立表空间或扩张新库的表空间CREATE TABLESPACE orcl_index_o1 DATAFILE SIZE 10240M AUTOEXTEND OFF, SIZE 10240M AUTOEXTEND OFFLOGGINGEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEME... 阅读全文
posted @ 2012-03-22 16:54 DB&*NIX 阅读(718) 评论(0) 推荐(0) 编辑
摘要: $ORACLE_HOME\RDBMS\ADMIN\UTLRP.SQL 阅读全文
posted @ 2012-03-22 11:41 DB&*NIX 阅读(150) 评论(0) 推荐(0) 编辑