梦想有多远

1.修改xdb端口

SQL> call  dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get() ,  ‘/xdbconfig/sysco
  nfig/protocolconfig/httpconfig/http-port/text()’,  8081))

查询表空间使用和未使用的空间

SELECT b.tablespace_name, mbytes_alloc, mbytes_free
  FROM (SELECT   ROUND (SUM (BYTES) / 1024 / 1024) mbytes_free,
                 tablespace_name
            FROM dba_free_space
        GROUP BY tablespace_name) a,
       (SELECT   ROUND (SUM (BYTES) / 1024 / 1024) mbytes_alloc,
                 tablespace_name
            FROM dba_data_files
        GROUP BY tablespace_name) b
 WHERE a.tablespace_name(+) = b.tablespace_name
       AND b.tablespace_name IN (’USERS’, ‘SYSTEM’)

3当移动一个表的多个分区时的脚本

BEGIN
   FOR x IN (SELECT partition_name
               FROM user_tab_partitions
              WHERE table_name = ‘BIG_TABLE2′)
   LOOP
      EXECUTE IMMEDIATE    ‘alter table big_table2 move partition ‘
                        || x.partition_name;
   END LOOP;
END;
/

This entry was posted on 星期二, 十一月 20th, 2007 at 20:28 and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.