Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

(ת)oracleºÍdb2Çø±ð

ÏîÄ¿ÖÐÒ»Ö±¶¼ÊÇÓÃdb2£¬ËùÒÔ¶Ôdb2Ò²ËãÓиöÒ»Öª°ë½â£¬¶ø¶ÔoracleÔòÊÇÖªÖ®ÉõÉÙ£¬Ò»Ö±¿àÓÚûÓлú»áÀ´Á·ÊÖ¡£×î½üÏîÄ¿×éÔÚ×ödb2µ½oracleµÄÇ¨ÒÆ£¬ÖÕÓÚ´þ×Å»ú»áÁË¡£½ñÌì¼òµ¥ËµÐ©ÔÚʵ¼ÊÏîÄ¿Óöµ½µÃһЩÎÊÌ⣬ÒÔºóÔÙÂýÂý²¹³ä¡£Í¬Ê±Ò²Ï£ÍûÈÊÈË־ʿ¶à¶àÖ¸µã¡£   
         ÓÉÓÚ ......

oracle¼àÌýÆô¶¯²»ÁË

1 ÎÊÌâÃèÊö
oracleÊý¾Ý¿âÔÚ·þÎñÆ÷ÉÏÔËÐÐÕý³££¬µ«ÊDz»ÄÜͨ¹ýÍøÂçÁ¬½Ó£¨¼´Ê¹Óÿͻ§¶Ë²»ÄÜÁ¬½ÓÊý¾Ý¿â£¬ÔÚ·þÎñÆ÷¶ËÕý³££¬Õï¶ÏµÄ³õ²½Ô­ÒòΪ¼àÌýÆ÷ÎÊÌ⣩¡£ÔÚ·þÎñÆ÷¶ËʹÓÃÒÔÏÂÃüÁ
bash-3.1$ cd $ORACLE_HOME/bin
bash-3.1$ ./lsnrctl
LSNRCTL> status
½á¹û³öÏÖ£º
CONNECT (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=E ......

oracle Êý¾Ýͬ²½¸´ÖƹÊÕϽâ¾ö

¹ÊÕϽâ¾ö£ºoracle10g Êý¾Ý¿â¸´ÖÆÍ¬²½
ºÇºÇ¡£oracleÎÒÊǸö²ËÄñ£¬Ã»»¨¹¦·òÑо¿Ëü£¬µ«ÎÒ»¹ÊǼæÈÎdba£¬Ä¿Ç°oracleÈ«²¿ÊÇÓÉÒÔǰµÄdba´´½¨µÄ£¬oracleȷʵºÃ¡£»ù±¾Ã»Óгö¹ýÎÊÌ⣬ÎÒÒ²¾Í»ù±¾²»¹ÜËüÁË£¬¿ÉÊÇÓÉÓÚ×Ô¼º´ÖÐÄ´óÒ⣬ÔÚÒ»´ÎÐ޸ķþÎñÆ÷µØÖ·Ê±ºò£¬Êý¾Ý¿âÀïµÄtns...Õâ¸öÅäÖÃÎļþÍüÁËÐ޸쬽á¹ûµ¼ÖÂͬ²½Ê§°Ü£¬µÈÎÒ·¢ÏÖµÄʱºò£¬ ......

Ubuntu°²×°OracleºóÔËÐÐSqlplus±¨´íµÄ½â¾ö°ì·¨

µ±ÔËÐÐsqlplus.shµÄʱºò±¨³ö£º
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
ºÜÆæ¹Ö
nls_lang.shµÄ114ÐÐǰºóÊÇÕâÑùµÄ
if [[ -n "$LC_ALL" ]]; then
  locale=$LC_ALL
elif [[ -n "$LANG" ]]; then
  locale=$LANG
else
  locale=
fi
[[ÓдíÎ󣿲»¿ ......

[ת]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ºÅ