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

oracle 10g ´íÎó ORA 01653 µÄ½â¾ö¹ý³Ì

ÔçÉÏÓû§·´Ó¦ÔÚ²Ù×÷ÓÃÓÑNCʱ±¨´í ORA-01653 £¬ÏêϸÐÅÏ¢£ºORA-01653: ±í NCV35.GL_DETAIL ÎÞ·¨Í¨¹ý 1024 (ÔÚ±í¿Õ¼ä NNC_DATA01 ÖÐ) À©Õ¹¡£
ÔÚÈÕÖ¾Îļþ F:\oracle\product\10.2.0\admin\CUTC\bdump\alert_cutc.logÖУ¬³öÏÖ
Thu Mar 04 10:59:21 2010
ORA-1653: unable to extend table NCV35.GL_DETAIL by 1024 in                 tablespace NNC_DATA01
ORA-1653: unable to extend table NCV35.GL_DETAIL by 1024 in                 tablespace NNC_DATA01
......
³õ²½ÅжÏÊDZí¿Õ¼äÎÞ·¨À©Õ¹¡£
Ö´ÐÐ
ALTER DATABASE
    DATAFILE 'E:\NCDATA\NNC_DATA01.ORA' AUTOEXTEND
    ON NEXT 50M MAXSIZE UNLIMITED
ÎÊÌâ½â¾ö¡£


Ïà¹ØÎĵµ£º

oracle³éÈ¡º¯Êý extract()

auhtor£ºskate
time£º2010/03/03
oracle³éÈ¡º¯Êý
½ñÌìÅóÓÑÎʸöÎÊÌ⣬ÈçºÎ³éȡʱ¼äµÄ“Сʱ”
oracleµÄ³éÈ¡º¯ÊýÊÇ extrac()Óï·¨:
SELECT EXTRACT(YEAR from SYSDATE) from DUAL; return Current Year
SELECT EXTRACT(MONTH from SYSDATE) from DUAL; return Current Month
SELECT EXTRACT(DAY from SYSDA ......

oracleÖеÄdual±íÏê½â

1.DUAL±íµÄÓÃ;
Dual ÊÇ OracleÖеÄÒ»¸öʵ¼Ê´æÔÚµÄ±í£¬ÈκÎÓû§¾ù¿É¶ÁÈ¡£¬³£ÓÃÔÚûÓÐÄ¿±ê±íµÄSelectÓï¾ä¿éÖÐ
--²é¿´µ±Ç°Á¬½ÓÓû§
SQL> select user from dual;
USER
------------------------------
SYSTEM
--²é¿´µ±Ç°ÈÕÆÚ¡¢Ê±¼ä
SQL> select sysdate from dual;
SYSDATE
-----------
2007-1-2 ......

Oracleʱ¼ä¼ÆËã

ÈÕÆÚ¸ñʽ²ÎÊý   º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY    ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD   ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW   ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......

oracleʵÀýÃû¡¢Êý¾Ý¿âÃûÓë·þÎñÃûµÄÀí½â תÌù²Ì¿¡

    ʵÀýÃû£¨instance_name£©£¬Ò»¸öÓÃÓÚÊý¾Ý¿âºÍ²Ù×÷ϵͳ֮¼äͨÐŵıêÖ¾£¬Êý¾Ý¿âºÍ²Ù×÷ϵͳ֮¼äÒª½øÐн»»¥ÓõľÍÊÇʵÀýÃû£¬ÊµÀýÃû¿ÉÒÔºÍÊý¾Ý¿âÃûÏàͬ£¬Ò»»áÔÙ˵Êý¾Ý¿âÃû£¬Ò»°ãÒ»¸öÊý¾Ý¿âÃû¶ÔÓ¦Ò»¸öʵÀýÃû£¬Ò»¶ÔÒ»¹Øϵ£¬µ«ÔÚoracleµÄ¼¯ÈºÓ¦ÓÃÖУ¬Êý¾Ý¿âÃûºÍʵÀýÃû¾ÍÊÇÒ»¶Ô¶àµÄ¹ØϵÁË¡£
¡¡¡¡²é¿´ÊµÀýÃû£ºsele ......

Oracle RAC Æô¶¯Óë¹Ø±Õ


Ò». ¼ì²é¹²ÏíÉ豸
Ò»°ãÇé¿öÏ£¬ ´æ·ÅOCR ºÍ Voting Disk µÄOCFS2 »òÕßraw ¶¼ÊÇ×Ô¶¯Æô¶¯µÄ¡£ Èç¹ûËûÃÇûÓÐÆô¶¯£¬RAC ¿Ï¶¨ÊÇÆô¶¯²»Á˵ġ£ 
1.1 Èç¹ûʹÓÃocfs2µÄ£¬¼ì²éocfs2 ×´Ì¬
/etc/init.d/o2cb status
ÔÚ¹ÒÔØ֮ǰ£¬/etc/init.d/o2cb st ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ