ÔÚWindows 7 Ï°²×° Oracle 10g ¹ý³Ì
£¨ºìÉ«²¿·ÖΪÐÞ¸ÄÄÚÈÝ£©
µÚÒ»²½£¬ÔÚ´ÅÅÌϽ¨Ò»¸öÎļþ¼Ð£¬×¢Òâ²»ÒªÓпոñ£¬·ñÔòoracle°²×°Ê±»á³öÏÖ¾¯¸æ¡£
µÚ¶þ²½£¬ÓÃÓÚ½øÈë°²×°½çÃæºó£¬¼ì²â»·¾³ÔÚ°²×°Îļþ¼ÐÀïËÑË÷ "refhost.xml"£¬¹²2¸öÎļþ¡£
ÓüÇʱ¾´ò¿ª£¬¿´µ½
<!--Microsoft Windows vista-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.0"/>
</OPERATING_SYSTEM>
ÕâÑùµÄ´úÂ룬ȻºóÔÚÏÂÃæÌí¼ÓÕâЩ£¨xmlÉÏÏÂÎÄÖ®¼ä²»ÄÜÓпոñ£©
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
µÚÈý²½£¬ÐÞ¸Äoracle°²×°ÎļþÏÂinstallµÄoraparam.iniÎļþ£¬ÐÞ¸ÄÈçÏÂ
[Oracle]
DISTRIBUTION=TRUE
SOURCE=../stage/products.xml
LICENSE_LOCATION=
JRE_LOCATION=../stage/Components/oracle.swd.jre/1.4.2.14.0/1/DataFiles
JRE_MEMORY_OPTIONS="
-mx96m"
DEFAULT_HOME_LOCATION=oracle\product\10.2.0\db
DEFAULT_HOME_NAME=OraDb10g_home
NO_BROWSE=/net
NLS_ENABLED=TRUE
BOOTSTRAP=TRUE
OUI_VERSION=10.2.0.3.0
##
JRE_VERSION is only for Windows. This is to copy accessbridge dlls
JRE_VERSION=1.4.2
#SHOW_HOSTNAME=ALWAYS_SHOW
shows the hostname panel always
#SHOW_HOSTNAME=NEVER_SHOW does not
the hostname panel
#SHOW_HOSTNAME=CONDITION_SHOW shows the hostname
panel on condition
SHOW_HOSTNAME=NEVER_SHOW
#THIN_JDBC_FILENAME is
optional and defaults to classes12.jar
#The value specified for this
should be packaged with OUI, and should
#be relative to <OUI
expanded stagedir>/jlib/
THIN_JDBC_FILENAME=classes12.jar
#RUN_OUICA
specifies the batch script name that needs to be run
#The script is
ouica.bat for win32, and ouica.sh for solaris.
#If the value is not
specified, then the OUICA script is not run
RUN_OUICA=ouica.bat
CLUSTERWARE={"oracle.crs","10.1.0.2.0"}
SILENT_VARIABLE_VALIDATION=TRUE
[Certified
Versions]
#You can customise error message shown for failure,
provide value for CERTIFIED_VERSION_FAILURE_MESSAGE
Windows=5.0,5.1,5.2,6.
Ïà¹ØÎĵµ£º
SolarisÉÏOracle×Ô¶¯Æô¶¯ÉèÖÃ
===========================================================
×÷Õß: tianying(http://tianying.itpub.net)
·¢±íÓÚ: 2005.04.03 21:51
·ÖÀà: ³õʼ·ÖÀà
³ö´¦: http://tianying.itpub.net/post/2852/24823
---------------------------------------------------------------
¸ÕÔ ......
1¡¢
Á¬½ÓÊý¾Ý¿â
connect uuu/ooo
connect
sys/ok as sysdba
2¡¢
´´½¨±í¿Õ¼ä
create tablespace stu(±í¿Õ¼äÃû
) datafile
‘
e:\stu.dbf
’
size 100m autoextend on next 5m maxsize 500m;
3¡¢& ......
²é¿´»ØÊÕÕ¾Öбí
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
»Ö¸´±í
SQL
>flashback table test_drop to before drop;»ò
SQL
>flashback table "BIN$b+XkkO1RS5K10uKo9BfmuA==$0" to befor ......
½üÈÕÔÚ²éѯijÏîÈÕÖ¾µÄʱºò£¬·¢ÏÖ²éѯ·Ç³£»ºÂý£¬¸ù¾ÝÒÔÍùµÄ¾ÑéÕâÊÇÓÉÓÚij¸öÈÕÖ¾±í¹ý´óÒýÆðµÄ£¬ÎªÁ˼ӿì²éѯ£¬¾ö¶¨½«´ó²¿·ÖµÄÀúÊ·Êý¾ÝǨÒƵ½ÁíÍâÒ»¸ö±íÖУ¬±¾ÎÄÖ÷Òª¼Ç¼ɾ³ýÕâ¸ö´ó±íµÄ¹ý³Ì£¬¾Í½â¾öÎÊÌâ¶øÑÔ»¹Óкܶ෽·¨£¬µ«ÊDZ¾ÎIJàÖصãÔÚÓÚÈçºÎ´¦Àí´óÊý¾ÝÁ¿É¾³ýµÄ²Ù×÷£¬¼°ÆäÉƺó¹¤×÷¡£
Ê×ÏÈ¿´¿´ÎÒÃÇÒª×öÊý¾ÝǨÒƵıíËùÕ¼µÄ ......
ͨ¹ý select * from table whereid=16701 for update ËøסһÕűí
ͨ¹ýÒÔÏÂÓï¾ä¿É²éѯ³ö±»ËøסµÄ¶ÔÏó
SELECT OBJECT_ID,
SESSION_ID,
SERIAL#,
ORACLE_USERNAME,
&nb ......