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
Ïà¹ØÎĵµ£º
¶ÔÿһÐÐÊäÈëÖµ½øÐмÆË㣬µÃµ½ÏàÓ¦µÄ¼ÆËã½á¹û£¬·µ»Ø¸øÓû§£¬Ò²¾ÍÊÇ˵£¬Ã¿ÐÐ×÷Ϊһ¸öÊäÈë²ÎÊý£¬¾¹ýº¯Êý¼ÆËãµÃµ½Ã¿ÐеļÆËã½á¹ûÊǵ¥Ðк¯Êý¡£
Ò»¡¢×Ö·ûº¯Êý
1¡¢×Ö·û´®´óСдת»»
(1)LOWER (strexp) ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд
(2)UPPER (strexp) ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ× ......
#! /bin/bash
if [ -f ~/.bashrc ];then
. ~/.bash_profile
fi
export script=/home/oracle/script
export bakdata_destination=/u02/rman_backup/data
export baklog_destination=/u02/rman_backup/log
export datadir=`date +'%Y_%m_%d'`
export days=`date +'%w'`
if ! test -d $script
then
&nb ......
Ò»¡¢oracleµ¼³öexcel
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨---Óù¤¾ßplsql dev
Ö´ÐÐFile =>new Report Window ¡£ÔÚsql±êÇ©ÖÐдÈëÐèÒªµÄsql£¬µã»÷Ö´Ðлò°´¿ì½Ý¼üF8£¬»áÏȳԳö²éѯ½á¹û¡£ÔÚÓҲ๤¾ßÀ¸£¬¿ÉÒÔÑ¡Ôñ°´Å¥Áí´æÎªhtml¡¢copy as html¡¢export results£¬ÆäÖÐexport results°´Å¥ÖоͿÉÒÔµ¼³öexcelÎļþ¡¢csvÎļþ¡¢tsvÎļþ¡¢xmlÎļþ¡ ......
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»ù±¾¸ÅÄî/ÊõÓï
Êý¾Ý¿â£¨Database£©
ÊÇ´ÅÅÌÉÏ´æ´¢µÄÊý¾ÝµÄ¼¯ºÏ£¨°üÀ¨ÅäÖÃÎļþ¡¢Êý¾ÝÎļþ¡¢ÈÕÖ¾ÎļþºÍ¿ØÖÆÎÄ
¼þµÈ£©
Êý¾Ý¿âʵÀý£¨Database Instance£©
ÔËÐÐÔÚÊý¾Ý¿âÎļþÉϵÄÒ»×éOracleºǫ́½ø³Ì/Ïß³ÌÒÔ¼°Ò»¸ö¹²ÏíÄÚ´æÇø¡£Êý¾Ý
¿â¿ÉÒÔÓÉʵÀý×°ÔØºÍ´ò¿ª¡£
Êý¾Ý¿â·þÎ ......