Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle ÒÆ¶¯¸ßˮλ£º

²é¿´±íµÄ´óС£»
select a.blocks,a.bytes,a.bytes/1024/1024 from user_segments a
where a.segment_name='B_M_DZYH_CUST_SIGN_FACT';
Ê×ÏÈ
create table TEST_1228 as select * from user_tables;
insert into TEST_1228  select * from TEST_1228 ;
insert into TEST_1228  select * from TEST_1228 ;
insert into TEST_1228  select * from TEST_1228 ;
insert into TEST_1228  select * from TEST_1228 ;
insert into TEST_1228  select * from TEST_1228 ;
commit;
²é¿´±íµÄ¿Õ¼ä´óС:¼Ç¼Ϊ1
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
ɾ³ý±í
delete from TEST_1228 ;
commit;
²é¿´±íµÄ¿Õ¼ä´óС:¼Ç¼Ϊ2
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
ÒÆ¶¯¸ßˮλ£º
alter table TEST_1228 enable row movement
alter table TEST_1228 shrink space
²é¿´±íµÄ¿Õ¼ä´óС:¼Ç¼Ϊ3
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
¶Ô±È1£¬2£¬3½á¹û£¬¼´¿É


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

²»ÊÇORACLEµÄÎÊÌâ

                                          ²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
    ......

java²Ù×÷oracleÊý¾Ý¿âÖеÄblob×Ö¶Î

oracleÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.R ......

OracleÖйúCEOºú²®ÁÖ£º¹ÜÀí¾ÍÊǹµÍ¨

¶Ôºú²®ÁֵIJɷÃÈçÆÚÔÚλÓÚ±±¾©¹úóµÄOracleÖйú×ܲ¿½øÐУ¬µ±¼ÇÕß°Ñ×¼±¸ºÃµÄ²É·ÃÌá¸ÙµÝ¸øºú²®ÁÖÖ⣬ÒÔΪËû»áÏñÐí¶àÊÜ·ÃÕßÒ»ÑùÌÏÌϲ»¾øÆðÀ´£¬Ë­ÖªËûÖ»ÊÇ¿´ÁËÒ»ÑÛ˵£º“»¹ÊÇÒ»ÆðÌÖÂÛ°É£¬Îҿɲ»Ô¸³ª¶À½ÇÏ·¡£”
¡¡¡¡ÔÚOracleÖйú£¬ºú²®ÁÖÊÇÒ»¸öÇÅÁº£¬Ò»¸öÓë×ܲ¿ÓëÖйúÔ±¹¤Ö®¼ä¹µÍ¨µÄÇÅÁº£¬Ò»¸öÕ½ÂÔÖÆ¶¨ÓëÖ´ÐÐÖ®¼äµÄÇÅ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ