oracle¹éµµÄ£Ê½ÐÞ¸Ä
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 Partitioning, OLAP and Data Mining options
SQL>
SQL> archive log list;
Êý¾Ý¿âÈÕ־ģʽ ·Ç´æµµÄ£Ê½
×Ô¶¯´æµµ ½ûÓÃ
´æµµÖÕµã USE_DB_RECOVERY_FILE_DEST
×îÔçµÄÁª»úÈÕÖ¾ÐòÁÐ 112
µ±Ç°ÈÕÖ¾ÐòÁÐ 114
SQL> shutdown immediate;
Êý¾Ý¿âÒѾ¹Ø±Õ¡£
ÒÑ¾Ð¶ÔØÊý¾Ý¿â¡£
ORACLE Àý³ÌÒѾ¹Ø±Õ¡£
SQL> startup mount;
ORACLE Àý³ÌÒѾÆô¶¯¡£
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 230689668 bytes
Database Buffers 373293056 bytes
Redo Buffers 7135232 bytes
Êý¾Ý¿â×°ÔØÍê±Ï¡£
SQL> alter database archivelog;
Êý¾Ý¿âÒѸü¸Ä¡£
SQL> alter database open;
Êý¾Ý¿âÒѸü¸Ä¡£
TNS´íÎó£º
C:\Documents and Settings\Administrator>set oracle_sid=sgxxcyj
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
LogMinerÌṩÁËÒ»¸ö´¦ÀíÖØ×öÈÕÖ¾Îļþ²¢½«ÆäÄÚÈÝ·Òë³É´ú±í¶ÔÊý¾Ý¿âµÄÂß¼²Ù×÷µÄSQLÓï¾äµÄ¹ý³Ì¡£LogMinerÔËÐÐÔÚOracle°æ±¾8.1»òÕ߸ü¸ß°æ±¾ÖС£
Ò»£¬ÈçºÎʹÓÃLogminer:
ÏÈÒª°²×°logminerµÄÁ½¸ö°ü£»ÒÔSYSÓû§ÔËÐÐÏÂÃæÁ½¸ö½Å±¾,ÆäÖеÚÒ»¸ö½Å±¾dbmslm.sqlÓÃÀ´´´½¨DBMS_LOGMNR°ü£¬¸Ã°üÓÃÀ´·Ö ......
<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......
MDSYS.CS_SRS ----- ¸Ã±í¶¨ÒåÁË×ø±êϵµÄÃû×Ö¼°ÆäÔÚOracle SpatialÖеÄIDÖµµÈ£¬ÕâÐ©×ø±êϵ¶¼ÊÇÓÉOpen-GIS¹«²¼µÄ¡£Ä¿Ç°¶¨ÒåµÄ×ø±êϵÒѾ´ïµ½1018¸ö¡£
MDSYS.SDO_ANGLE_UNITS ----- ¸Ã±í¶¨ÒåÁ˽Ƕȵ¥Î»£¬·Ö±ðÊÇDegree,Gon,Grad,Minute,Radian,Second
MDSYS.SDO_DIST_UNITS ----- ¸Ã±í¶¨ÒåÁ˾àÀëµÄµ¥Î»¡£±ÈÈçkm,m£¬¹²ÓÐ27ÖÖ¾à ......