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

ORACLE³£¼ûÎÊÌâ1000ÎÊ(Ö®Ò»)

ORACLE³£¼ûÎÊÌâ1000ÎÊ(Ö®Ò»)
תÌù ×÷Õß:  CCBZZP - ]8 L1 m: @) P9 }
´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓëµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌ⣬Ìرð¶ÔÐÂÊÖÀ´Ëµ£¬½ñÌìÎÒ¼òµ¥°ÑËû×ܽáһϣ¬·¢²¼¸ø´ó¼Ò£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú£¡5 ]" z2 z0 ?( n6 q2 W
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ.
- M/ D* W% x% f' H$ N* ]" m  I" W
4 S+ R; y0 b( o, ~0 q  @  C1. Oracle°²ÑâÍê³ÉºóµÄ³õʼ¿ÚÁî?
; K' T9 ^; k& n1 o" X* D: B: c9 r8 Y
  ¡¡internal/oracle
# u/ p% X4 W4 r9 j3 I2 e8 t$ _7 }0 K0 \: @6 h
¡¡¡¡sys/change_on_install
2 Y( W2 m+ u  a5 p# ]' T8 c" \" g+ g( n5 s/ M; X* L" Y! f" ~
¡¡¡¡system/manager
& j  \+ G0 w! a% L$ X4 H+ Z& P
+ B: ]2 W* E! \3 w¡¡¡¡scott/tiger
- V$ e: |; C+ N* r: P% J7 k# n5 z8 ?
¡¡¡¡sysman/oem_temp
/ N- P* [% J' ^
! L# D& Z+ h0 x* x$ s2. ORACLE9IAS WEB CACHEµÄ³õʼĬÈÏÓû§ºÍÃÜÂ룿
- A5 u) x4 @5 S% S( R9 I$ h, ~# B( C) X" l6 K8 ^' a
   administrator/administrator. Y$ w, [/ a0 m8 ^6 X
1 R1 e0 X. n/ T7 Z' f
" o9 g: @" I. w2 Q7 C5 S" ^5 f/ ^) K3. oracle 8.0.5Ôõô´´½¨Êý¾Ý¿â?6 u" y9 K5 a6 h  u$ d
* U# b2 s5 N7 u; A- \   ÓÃorainst¡£Èç¹ûÓÐmotif½çÃ棬¿ÉÒÔÓÃorainst /m( _+ ~, e! e; d! x: e
1 ]2 a5 F+ b: `1 d4. oracle 8.1.7Ôõô´´½¨Êý¾Ý¿â?) X6 c% A2 T" Q1 V# S; E) d# ?3 L( X
$ w" G; Y. B' y: R   dbassist 1 l* x& W4 t- g% v+ n
% {9 N. O: [& X' E' s2 d
5. oracle 9i Ôõô´´½¨Êý¾Ý¿â?
& A- @% f7 [9 R1 q
" L) Y& F+ ~2 v+ U' C- s0 ?3 Z& a9 W   dbca
8 p' M+ F1 m% G/ M  C! B( b
2 T! ^0 b1 r: G; `2 k# L6. oracleÖеÄÂãÉ豸ָµÄÊÇʲô?
7 ?! G- S- l; u4 q& ]2 \
5 ?2 a9 L; H, s1 B+ N  ÂãÉ豸¾ÍÊÇÈƹýÎļþϵͳֱ½Ó·ÃÎʵĴ¢´æ¿Õ¼ä
  N# Z$ a  z; Y* R
4 g6 X/ p4 z8 I# T2 f7. oracleÈçºÎÇø·Ö 64-bit/32bit °æ±¾£¿£¿£¿
0 j8 U: _8 N6 t, z/ X  ]! E/ s! Y' L0 J! M
$ sqlplus '/ AS SYSDBA'
% s6 Y0 k0 s8 JSQL*Plus: Release 9.0.1.0.0 - Production on Mon Jul 14 17:01:09 2003 : h- m' |- l0 t& G/ E7 Z1 G
(c) Copyr


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

ORACLE³£ÓÃÊýÖµº¯Êý¡¢×ª»»º¯Êý¡¢×Ö·û´®º¯Êý½éÉÜ


µ¥Öµº¯ÊýÔÚ²éѯÖзµ»Øµ¥¸öÖµ£¬¿É±»Ó¦Óõ½select£¬where×Ӿ䣬start withÒÔ¼°connect by ×Ó¾äºÍhaving×Ӿ䡣
(Ò»).ÊýÖµÐͺ¯Êý(Number Functions)
    ÊýÖµÐͺ¯ÊýÊäÈëÊý×ÖÐͲÎÊý²¢·µ»ØÊýÖµÐ͵ÄÖµ¡£¶àÊý¸ÃÀຯÊýµÄ·µ»ØÖµÖ§³Ö38λСÊýµã£¬ÖîÈ磺COS, COSH, EXP, LN, LOG,
SIN, SINH, SQRT, TAN, and TANH Ö ......

ORACLE JOBºÍ´æ´¢¹ý³ÌµÄÏà¹Ø²éѯ

²é¿´Ïà¹ØjobÐÅÏ¢
¡¡¡¡1¡¢Ïà¹ØÊÓͼ
¡¡¡¡dba_jobs
¡¡¡¡all_jobs
¡¡¡¡user_jobs
¡¡¡¡dba_jobs_running °üº¬ÕýÔÚÔËÐÐjobÏà¹ØÐÅÏ¢ ¡¡
²é¿´´æ´¢¹ý³Ì packageµÈÏà¹Ø¹ý³Ì
select * from user_source where text like '%Òª²éµÄÄÚÈÝ%' ......

ÓÃOracleÉÁ»Ø¹¦Äָܻ´Å¼È»¶ªÊ§µÄÊý¾Ý

Õª Òª£º±¾ÎÄÌá³öÁËÉÁ»Ø¹¦ÄܵÄÔ­Àí£¬ÃèÊöÁËÀûÓÃOracle 9i»òOracle 10gµÄÉÁ»Ø¹¦ÄܽøÐлָ´Å¼È»¶ªÊ§Êý¾ÝµÄ·½·¨¡£
¹Ø¼ü´Ê£ºOracle£»ÉÁ»Ø£»»Ø¹ö¶Î£»Êý¾Ý»Ö¸´
ÒýÑÔ
ÈËΪµÄ´íÎóÊÇÊý¾Ý¿âϵͳʧ°ÜµÄÖØÒªÔ­ÒòÖ®Ò»£¬¸ù¾Ýµ÷²éÔ¼40%µÄϵͳÎÊÌâÊDzÙ×÷ʧÎó»òÕßÓû§´íÎóÒýÆðµÄ£¬ÕâЩÈËΪµÄ´íÎóÓÖÌرðÄÑÒÔ±ÜÃâ¡£´«Í³Éϵ±·¢ÉúÊý¾Ý¶ªÊ§¡¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ