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

ת:ORACLE ¶à±í¹ØÁª UPDATE Óï¾ä


ת:ORACLE
¶à±í¹ØÁª UPDATE Óï¾ä
Ô­Ìû£ºhttp://www.cnblogs.com/miley/archive/2010/04/15/1712617.html
  ΪÁË
·½±ãÆð¼û
,½¨Á¢ÁËÒÔϼòµ¥Ä£ÐÍ
,ºÍ¹¹ÔìÁ˲¿·Ö²âÊÔÊý¾Ý
:
   ÔÚij¸öÒµ
ÎñÊÜÀí×Óϵͳ
BSSÖУ¬
  --¿Í»§×Ê
Áϱí
  create table customers
   (
   customer_id   number(8)    not null,  -- ¿Í»§±êʾ
   city_name     varchar2(10) not null,  -- ËùÔÚ³ÇÊÐ
   customer_type char(2)      not null,  -- ¿Í»§ÀàÐÍ
 
   ...
   )
  create unique index PK_customers on customers
(customer_id)
   ÓÉÓÚijЩ
Ô­Òò£¬¿Í»§ËùÔÚ³ÇÊÐÕâ¸öÐÅÏ¢²¢²»Ê²Ã´×¼È·£¬µ«ÊÇÔÚ
   ¿Í»§·þÎñ
²¿µÄ
CRM×ÓϵͳÖУ¬Í¨¹ýÖ÷¶¯·þÎñ»ñÈ¡Á˲¿·Ö
¿Í»§
20%µÄËùÔÚ
   ³ÇÊеÈ×¼
È·ÐÅÏ¢£¬ÓÚÊÇÄ㽫¸Ã²¿·ÖÐÅÏ¢ÌáÈ¡ÖÁÒ»ÕÅÁÙʱ±íÖУº
  create table tmp_cust_city
   (
   customer_id     number(8) not null,
   citye_name     varchar2(10) not null£¬
   customer_type  char(2)   not null
  )
 
 
1) ×î¼òµ¥µÄ
ÐÎʽ
   --¾­È·
ÈÏ
customers±íÖÐËùÓÐ
customer_idСÓÚ
1000¾ùΪ
'±±¾©
'
   --1000ÒÔÄڵľùÊǹ«Ë¾×ßÏòÈ«¹ú֮ǰµÄ±¾³ÇÊеÄÀϿͻ§
:)
   update customers
   set    city_name='±±¾©
'
   where  customer_id<1000
 
2) Á½±í
(¶à±í
)¹ØÁª
update -- ½öÔÚ
where×Ö¾äÖеÄÁ¬½Ó
   --Õâ´Î
ÌáÈ¡µÄÊý¾Ý¶¼ÊÇ
VIP£¬ÇÒ°üÀ¨ÐÂÔöµÄ
,ËùÒÔ˳±ã¸üпͻ§Àà±ð
   update customers   a       -- ʹÓñðÃû
   set    customer_type='01' --01 Ϊ
vip£¬
00ΪÆÕͨ
   where  exists (select 1
                  from   tmp_cust_city b
  &


Ïà¹ØÎĵµ£º

oracle ²Ù×÷±íʾÀý

1.´´½¨±í£º
       a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
           Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
       b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......

oracleË÷ÒýË鯬

author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......

oracle 10g em¡¢isqlplus·ÃÎʲ»Á˵ÄÎÊÌâ½â¾ö

Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§                    
http://ip:5560/isq ......

linux oracleËõС»Ø¹ö±í¿Õ¼ä´óСundotbs01.dbf


http://hi.baidu.com/lu_xinzhong/blog/item/4ff92b1725dec505c83d6d09.html
»Ø¹ö±í¿Õ¼ä´óС
-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄUNDO TABLESPACE
Create UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/orcl/UNDOTBS02.DBF' SIZE 100M REUSE AUTOEXTEND ON;
-- ÉèÖÃеıí¿Õ¼äΪϵͳUNDO_TABLESPACE
Alter SYSTE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ