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

Oracle ÒÆ¶¯Êý¾ÝÎļþµÄ²Ù×÷·½·¨

½«±í¿Õ¼äºÍÊý¾ÝÎļþ´ÓÒ»¸öλÖÃÒÆ¶¯µ½ÁíÒ»¸öλÖõIJÙ×÷·½·¨
Ò»£® OFFLINE
OFFLINE ·ÖΪALTER DATABASE Óë ALTER TABLESPACE OFFLINE£¬
ËûÃǵÄÇø±ð²Î¿´blog£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/29/4898800.aspx
°´Êý¾ÝÎļþÀ´£º
1.ÏȽ«ÏàÓ¦µÄÊý¾ÝÎļþ offline 
ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\DBA\TEST01.DBF' OFFLINE;
2.°ÑÊý¾ÝÎļþ copy µ½ÐÂλÖÃ
3. alter database rename file 'D:\ORACLE\ORADATA\DBA\TEST01.DBF' to 'D:\TEST01.DBF';
4. ½éÖʻָ´(offline Êý¾ÝÎļþ±ØÐëÒª½éÖʻָ´)
recover datafile 'D:\TEST01.DBF'
5. ½«ÏàÓ¦µÄÊý¾ÝÎļþ online
SQL>ALTER DATABASE DATAFILE 'D:\TEST01.DBF' ONLINE;
°´±í¿Õ¼äÀ´£º
1.ÏȽ«ÏàÓ¦µÄ±í¿Õ¼ä offline 
SQL>alter tablespace test offline; 
2.°ÑÊý¾ÝÎļþ copy µ½ÐÂλÖÃ
3. alter tablespace TEST  rename datafile 'D:\TEST01.DBF' to 'D:\ORACLE\ORADATA\DBA\TEST01.DBF'
4. ½«±í¿Õ¼ä online
SQL>alter tablespace test online;  
¶þ£® Shutdown Êý¾Ý¿â
1. ¹Ø±ÕÊý¾Ý¿â
C:>set ORACLE_SID=DBA
C:>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚÈÕ 11ÔÂ 29 11:14:02 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn sys/admin as sysdba
ÒÑÁ¬½Ó¡£
SQL> shutdown immediate
Êý¾Ý¿âÒѾ­¹Ø±Õ¡£
ÒѾ­Ð¶ÔØÊý¾Ý¿â¡£
ORACLE Àý³ÌÒѾ­¹Ø±Õ¡£
SQL>
2. °ÑÊý¾ÝÎļþ copy µ½ÐÂλÖÃ
3. rename datafile
SQL> startup mount
ORACLE Àý³ÌÒѾ­Æô¶¯¡£
Total System Global Area  289406976 bytes
Fixed Size                  1248576 bytes
Variable Size              71303872 bytes
Database Buffers          209715200 bytes
Redo Buffers                7139328 bytes
Êý¾Ý¿â×°ÔØÍê±Ï¡£
SQL> alter database rename file 'D:\ORACLE\ORADATA\DBA\TEST01.DBF' to 'D:\TEST01
.DBF';
Êý¾Ý¿âÒѸü¸Ä¡£
SQL> alt


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

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

ORACLEËøÐÅÏ¢

²é¿´±»ËøµÄ±í
select   p.spid,a.serial#,
c.object_name,b.session_id,b.oracle_username,b.os_user_name   from  
v$process   p,v$session   a,   v$locked_object   b,all_objects   c  
where   p.addr=a.p ......

ORACLEÖд¥·¢DBWR½ø³ÌµÄʼþ~

½ñÌìÔÚÒ»±¾ÊéÉÏ¿´µ½µÄ£¬¸Ð¾õͦȫµÄ¡£Ó¡ÏóÖÐ×Ô¼ºÒѾ­²»ÖªµÀ°Ù¶ÈÁ˶àÉÙ´ÎÕâ¸öÎÊÌ⣬½ñÌì¾Í¼ÇÏÂÀ´°É£¬·½±ãÒÔºó²éѯ¡£
Êý¾Ý¿âд½ø³ÌÔÚÒÔÏÂʼþÖ®Ò»·¢Éúʱ°ÑÊý¾Ý¿â¸ßËÙ»º³åÇøµÄÊý¾Ýдµ½Êý¾ÝÎļþÉÏ:
µ±Ô໺³åÇøµÄÊýÁ¿³¬¹ýÁËËùÉ趨µÄÏÞ¶î
µ±ËùÉ趨µÄʱ¼ä¼ä¸ôÒѵ½
µ±Óнø³ÌÐèÒªÊý¾Ý¿â¸ßËÙ»º³åÇøÈ´ÕÒ²»µ½¿ÕÏеĻº³åÇøÊ±
µ±¼ì²éµ ......

ORACLEµÄÈýÖÖ°²×°·½Ê½ºÍÁ¬½Ó·½Ê½~

ORACLE·þÎñÆ÷Ò»°ã°üÀ¨ÒÔÏÂÈýÖÖ°²×°·½Ê½
»ùÓÚÖ÷»ú·½Ê½£ºÔÚ´ËÅäÖÃÏ£¬Óû§¿ÉÖ±½ÓÔÚ°²×°ÁËÊý¾Ý¿âµÄ¼ÆËã»úÉϵǼORACLEÊý¾Ý¿â¡£
¿Í»§¶Ë-·þÎñÆ÷(client-server)£¨Á½²ãÄ£ÐÍ£©·½Ê½£ºÊý¾Ý¿âºÍ¿Í»§ÖÕ¶Ë·Ö±ð°²×°ÔÚ²»Í¬µÄ¼ÆËã»úÉÏ£¬Óû§¿Éͨ¹ýÍøÂç´Ó¸öÈ˼ÆËã»ú£¨¿Í»§¶Ë£©ÉÏ·ÃÎÊÊý¾Ý¿â¡£
¿Í»§¶Ë-Ó¦Ó÷þÎñÆ÷-·þÎñÆ÷(client-applicatio ......

[ת]Oracle,sql serverµÄ¿ÕÖµ(null)ÅжÏ


sql server
Ìæ»»null:isnull(arg,value)
Èç:select isnull(price,0.0) from orders                             ,Èç¹ûpriceΪnullµÄ»°£¬ÓÃ0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ