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

oracleÖеÄdual±íÏê½â

1.DUAL±íµÄÓÃ;
Dual ÊÇ OracleÖеÄÒ»¸öʵ¼Ê´æÔÚµÄ±í£¬ÈκÎÓû§¾ù¿É¶ÁÈ¡£¬³£ÓÃÔÚûÓÐÄ¿±ê±íµÄSelectÓï¾ä¿éÖÐ
--²é¿´µ±Ç°Á¬½ÓÓû§
SQL> select user from dual;
USER
------------------------------
SYSTEM
--²é¿´µ±Ç°ÈÕÆÚ¡¢Ê±¼ä
SQL> select sysdate from dual;
SYSDATE
-----------
2007-1-24 1
SQL> select to_char(sysdate,''yyyy-mm-dd hh24:mi:ss'') from dual;
TO_CHAR(SYSDATE,''YYYY-MM-DDHH2
------------------------------
2007-01-24 15:02:47
--µ±×÷¼ÆËãÆ÷ÓÃ
SQL> select 1+2 from dual;
1+2
----------
3
--²é¿´ÐòÁÐÖµ
SQL> create sequence aaa increment by 1 start with 1;
SQL> select aaa.nextval from dual;
NEXTVAL
----------
1
SQL> select aaa.currval from dual;
CURRVAL
----------
1
2¡¢¹ØÓÚDUAL±íµÄ²âÊÔÓë·ÖÎö
DUAL¾ÍÊǸöÒ»ÐÐÒ»ÁÐµÄ±í£¬Èç¹ûÄãÍùÀïÖ´ÐÐinsert¡¢delete¡¢truncate²Ù×÷£¬¾Í»áµ¼Öºܶà³ÌÐò³öÎÊÌâ¡£½á¹ûÒ²Òòsql*plus¡¢pl/sql devµÈ¹¤¾ß¶øÒì¡£
--²é¿´DUALÊÇʲôOBJECT
--DUALÊÇÊôÓÚSYS schemaµÄÒ»¸ö±í,È»ºóÒÔPUBLIC SYNONYMµÄ·½Ê½¹©ÆäËûÊý¾Ý¿âUSERʹÓÃ.
SQL> select owner, object_name , object_type from dba_objects where object_name like ''%DUAL%'';
OWNER OBJECT_NAME OBJECT_TYPE
---------- ----------------- ------------------
SYS DUAL TABLE
PUBLIC DUAL SYNONYM
--²é¿´±í½á¹¹£¬Ö»ÓÐÒ»¸ö×Ö¶ÎDUMMY£¬ÎªVARCHAR2(1)ÐÍ
SQL> desc dual
Name Type Nullable Default Comments
----- ----------- -------- ------- --------
DUMMY VARCHAR2(1) Y
--DUAL±íµÄ½á¹¹£º
create table SYS.DUAL
(
DUMMY VARCHAR2(1)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 16K
next 16K
minextents 1
maxextents 505
pctincrease 50
);
/*
ºÜÊÇÀ§»ó£¬ORACLEΪʲôҪÓÃVARCHAR(1)ÐÍ£¬ÓÃCHAR(1)ÄѵÀ²»ºÃô£¿´ÓÕâÑùµÄ±í½á¹¹À´¿´£¬DUAL±íÉè¼ÆµÄÄ¿µÄ¾ÍÊÇÒª¾¡¿ÉÄܵļòµ¥£¬ÒÔ¼õÉÙ¼ìË÷µÄ¿ªÏú¡£
»¹ÓУ¬DUAL±íÊǽ¨Á¢ÔÚSYSTEM±í¿Õ¼äµÄ£¬µÚÒ»ÊÇÒòΪDUAL±íÊÇSYSÕâ¸öÓû§½¨µÄ£¬±¾À´Ä¬Èϵıí¿Õ¼ä¾ÍÊÇSYSTEM£»µÚ¶þ£¬°ÑÕâ¸ö¿ÉÄܾ­³£±»²éѯµÄ±íºÍÓû§±í·Ö¿ªÀ´´æ·Å£¬¶ÔÓÚϵͳÐÔÄܵÄÊÇÓкô¦µÄ¡£
ÓÐÁË´´½¨ÁË±í¡¢´´½¨ÁËͬÒå´Ê


Ïà¹ØÎĵµ£º

Oracle»ØÊÕÕ¾£¬ora 38301´íÎó

ora-38301´íÎó,»ØÊÕÕ¾
ǰ¼¸ÌìÓÐͬʸæËßÎÒ£¬ÓÐ̨·þÎñÆ÷Éϵıí¿Õ¼äÎÞ·¨É¾³ý£¬ÈÃÎÒ¿´¿´¡£µÇ¼µ½·þÎñÆ÷£¬É¾³ý±í¿Õ¼ä£¬Êý¾Ý¿âͬʱ±¨ora-00604ºÍora-38301´íÎ󡣯ð³õÒÔΪÊÇÓÐÊý¾Ý¿â¶ÔÏó±»Ëø¶¨£¬ÖØÆôÊý¾Ý¿âºó£¬·¢ÏÖ»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£Googleºó·¢ÏÖ¿ÉÄÜÓë10gµÄÒ»¸öÐÂÌØÐÔ»ØÊÕÕ¾Óйأ¬Çå¿Õ»ØÊÕÕ¾purge recyclebinºó£¬½øÐÐɾ³ý»¹ÊDZ ......

ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä


ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐÐ ......

Oracle ORA 01110´íÎó½â¾ö·½·¨

     ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬½¨Á¢ÁËÒ»¸öÓû§test£¬È»ºóʹÓÃÃüÁîdrop user test cascadeɾ³ýÁËÓû§£¬½Ó×ÅҲɾ³ýÁËÕâ¸öÓû§µÄÊý¾ÝÎļþ/opt/oracle/oradata/test/testdata.dbf¡£µ±ÔڵǼÊý¾Ý¿âʱ£¬Äܹ»Æô¶¯ÊµÀý£¬µ«ÊÇ´ò²»¿ªÊý¾Ý¿â£¬ÏµÍ³±¨´í£º
             ORA-01157: c ......

ÔÚWindows 7ϰ²×°Oracle ½â¾ö·½·¨

Ê×ÏÈÕÒµ½Â·¾¶£º
E:\Oracle Enterprise_Standard Edition_11.1.0.7\database\stage\prereq\db\refhost.xml
ÈçϽڵ㣺
  <!--Microsoft Windows Vista-->
     <OPERATING_SYSTEM>
      <VERSION VALUE="6.0"/>
    </OPERAT ......

Oracle ϵͳ³£¼û´íÎó


p580  ÎÄÆ½
³£¼ûÎÊÌâÒ»:°º¹óµÄÊý¾Ý¿âÁ¬½Ó¿ªÏú
    ÔÚÓ¦Óÿª·¢ÖУ¬¿Í»§¶ËΪÁËijÖÖÊý¾Ý¿â²Ù×÷¶ø½øÐÐijÖÖÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ªµÄ²Ù×÷¡£ÕâÊÇ2000Äêǰºó¶¯Ì¬ÍøÒ³Ó¦ÓÃÀàÐͳ£¼ûµÄ´íÎó¡£ÔÚÕâÖÖÓ¦ÓÃÖУ¬Ã¿µ±Ò»¸öÓû§µ¥»÷Ò»¸öÍøÒ³£¬Èç¹ûÕâ¸öÍøÒ³Ç¶ÈëÁËÊý¾Ý¿â²Ù×÷£¬Ôò¸ÃÍøÒ³Òª½øÐÐÒ»´Î»òÈô¸É´ÎµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ