Oracle 10G ÖеĻØÊÕÕ¾
»ØÊÕÕ¾,´ÓÔÀíÉÏÀ´Ëµ¾ÍÊÇÒ»¸öÊý¾Ý×Öµä±í,·ÅÖÃÓû§DropµôµÄÊý¾Ý¿â¶ÔÏóÐÅÏ¢.Óû§½øÐÐDrop²Ù×÷µÄ¶ÔÏó²¢Ã»Óб»Êý¾Ý¿âɾ³ý,ÈÔÈ»»áÕ¼Óÿռä.³ý·ÇÊÇÓÉÓÚÓû§ÊÖ¹¤½øÐÐPurge»òÕßÒòΪ´æ´¢¿Õ¼ä²»¹»¶ø±»Êý¾Ý¿âÇåµô.Êý¾Ý¿âÓÐÁËÕâÑùµÄ¹¦ÄÜ,Äܹ»¼õÉٺܶ಻±ØÒªµÄÂé·³.¾³£¿´µ½¿ª·¢ÈËÔ±Îó°Ñ±íɾ³ý,¼±¼±Ã¦Ã¦ÕÒDBAÀ´Ïë°ì·¨µÄÇé¿ö,ÏàÐÅ,Ëæ×Å10GµÄ´ó·¶Î§Ó¦ÓÃ,ÕâÖÖÇéÐÎÓ¦¸Ã±È½ÏÉÙ¼ûÁË.DBAÖÎÀíÉϵÄÏà¹ØÐÅÏ¢¿ÉÒÔ´ÓUSER_recyclebin(DBA_recyclebin)ÖлñÈ¡.´ÓÏÖÔÚµÄBeta°æ±¾À´¿´,ÊÖ²áÉÏËù˵µÄͨ¹ýSQL*PlusµÄshow recycle bin ÃüÁî²é¿´»¹²»¿ÉÓÃ.ΪÁ˱ãÓÚ²âÊÔ,ÎÒÃÇ´´½¨ÁËÒ»¸ö±í¿Õ¼äFoo,´óСΪ1M,´´½¨ÁËÒ»¸öÓû§Foo,ĬÈϵıí¿Õ¼äΪFoo.
----------------------------------------------------
SQL>; CONNECT foo/foo
ÒÑÁ¬½Ó¡£
SQL>; SELECT table_name from user_tables;
δѡ¶¨ÐÐ
SQL>; DESC user_recyclebin
Ãû³Æ ÊÇ·ñΪ¿Õ? ÀàÐÍ
----------------------------------------- -------- ----------------
......
......
user_recyclebin´ó¶àÊÇ×Ô½âÊ͵Ä,ºÒå±È½ÏÇáÒ×Àí½â.
SQL>; SELECT object_name from user_recyclebin;
δѡ¶¨ÐÐ
SQL>; CREATE TABLE foo AS SELECT * from DUAL;
±íÒÑ´´½¨¡£
SQL>; SELECT table_name from user_tables;
TABLE_NAME
------------------------------
FOO
SQL>; DROP TABLE foo;
±íÒѶªÆú¡£
SQL>; SELECT table_name from user_tables;
TABLE_NAME
------------------------------
RB$$41888$TABLE$0
SQL>;
SQL>; SELECT object_name, original_name from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME
-------------------- --------------------
RB$$41888$TABLE$0 FOO
SQL>; DESC RB$$41888$TABLE$0
Ãû³Æ ÊÇ·ñΪ¿Õ? ÀàÐÍ
----------------------------------------- -------- -------------
DUMMY VARCHAR2(1)
µ±Ò»¸ö±í±»É¾³ý²¢Òƶ¯µ½"»ØÊÕÕ¾"ÖÐ,ËüµÄÃû×ÖÒª½øÐÐһЩת»».ÕâÑùµÄÄ¿µÄÏÔ¶øÒ×¼ûÊÇΪÁ˱ÜÃâ
ͬÀà¶ÔÏóÃû³ÆµÄÖØ¸´.(WindowsÉÏ,¾¹ýÁË·Ç·²µÄ´¦Àí,»ØÊÕÕ¾ÀïµÄ²Ù×÷ϵͳÎļþ¿ÉÒÔÖØÃû.)
ת»»ºóµÄÃû×Ö¸ñʽÈçÏÂ:
RB$$objn$object_type$version
ÆäÖеÄRB,´ú±íRecycle Bin. objnΪ±íµÄĿ¼¶ÔÏóºÅ. object_type±íʾ¶ÔÏóÀàÐÍ. version±íʾ°æ±¾ºÅ.
ÓÉÊý¾Ý¿âÖ¸¶¨¡£foo±í±»É¾³ýºó£¬ÔÚÊý¾Ý¿â»ØÊÕÕ¾Àï±ä³ÉÁËRB$$41888$TABLE$0 ¡£´ÓÃû×Ö¿ÉÒÔ¿´³ö£¬Õâ¸ö¶ÔÏóµÄ
ÀàÐÍÊÇTable£¬Versi
Ïà¹ØÎĵµ£º
linux ϰ²×°oracle ÊÇÒ»¼þºÜÁîÈËÍ·ÌÛµÄÊÂÇ飬ÎÒ°Ñ×Ô¼ºµÄ°²×°²½ÖèÄóöÀ´¸ø´ó¼Ò·ÖÏíһϡ£
Ò».linux·þÎñ¶ËµÄ°²×°.
1.ÏÂÔØoracle·þÎñ¶ËÈí¼þ,ÏÂÔØÍøÖ·ÈçÏÂ
http://www.oracle.com/technology/software/products/database/index.html
ÎÒÑ¡ÔñµÄ°æ±¾ÊÇ£ºOracle Database 10g Release 2 (10.2.0.1.0) for Linux x86-64
......
create or replace procedure aa1 is
v_aa varchar2(20);
v_bb varchar2(20);
va_aa varchar2(20);
va_bb varchar2(20);
va_number_aa number;
message varchar2(60);
CURSOR aas is
SELECT DISTINCT aa.aa, aa.bb from aa;
CURSOR aaas is
SELECT DISTINCT aaa.aa, aaa.bb from aaa where aaa.aa = v_aa ......
C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 13 15:26:31 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partition ......
Ò»£¬¼òµ¥½éÉÜ
ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´
ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢ create sequence
ÄãÊ×ÏÈÒªÓÐcreate sequence»òÕßcreate any sequenceȨÏÞ£¬
create sequence emp_sequence
&n ......
OracleÐÔÄÜÓÅ»¯¼¼ÇÉ
http://tech.it168.com/db/o/2006-06-15/200606151715426.shtml
1.Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
1.RULE(»ùÓÚ¹æÔò) 2.COST(»ùÓڳɱ¾) 3.CHOOSE(Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊ ......