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

Oracle³£¼ûÎÊÌâ

´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ¡£
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄ³õʼĬÈÏÓû§ºÍÃÜÂ룿
¡¡¡¡administrator/administrator
3. oracle 8.0.5ÔõçÛ´´½¨Êý¾Ý¿â?
¡¡¡¡ÓÃorainst¡£Èç¹ûÓÐmotif½çÃæ£¬¿ÉÒÔÓÃorainst /m
4. oracle 8.1.7ÔõçÛ´´½¨Êý¾Ý¿â?
¡¡¡¡dbassist
5. oracle 9i ÔõçÛ´´½¨Êý¾Ý¿â?
¡¡¡¡dbca
6. oracleÖеÄÂãÉ豸ָµÄÊÇʲçÛ?
¡¡¡¡ÂãÉ豸¾ÍÊÇÈÆ¹ýÎļþϵͳֱ½Ó·ÃÎʵĴ¢´æ¿Õ¼ä
7. oracleÈçºÎÇø·Ö 64-bit/32bit °æ±¾£¿£¿£¿
¡¡¡¡$ sqlplus / AS SYSDBA
¡¡¡¡SQL*Plus: Release 9.0.1.0.0 - Production on Mon Jul 14 17:01:09 2003
¡¡¡¡(c) Copyright 2001 Oracle Corporation. All rights reserved.
¡¡¡¡Connected to: ¡¡¡¡
¡¡¡¡Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production ¡¡¡¡
¡¡¡¡With the Partitioning option
¡¡¡¡JServer Release 9.0.1.0.0 - Production
¡¡¡¡SQL> select * from v$version; ¡¡
¡¡¡¡BANNER ¡¡¡¡
¡¡¡¡----------------------------------------------------------------
¡¡¡¡Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
¡¡¡¡PL/SQL Release 9.0.1.0.0 - Production ¡¡¡¡
¡¡¡¡CORE 9.0.1.0.0 Production
¡¡¡¡TNS for Solaris: Version 9.0.1.0.0 - Production
¡¡¡¡NLSRTL Version 9.0.1.0.0 - Production
¡¡¡¡SQL>
8. SVRMGRʲçÛÒâ˼£¿
¡¡¡¡svrmgrl£¬Server Manager.
¡¡¡¡9iÏÂûÓУ¬ÒѾ­¸ÄΪÓÃSQLPLUSÁË
¡¡¡¡sqlplus /nolog
¡¡¡¡±äΪ¹éµµÈÕÖ¾Ð͵Ä
9. ÇëÎÊÈçºÎ·Ö±æÄ³¸öÓû§ÊÇ´ÓÄĄ̈»úÆ÷µÇ½ORACLEµÄ?
¡¡¡¡SELECT machine , terminal from V$SESSION;
10. ÓÃʲçÛÓï¾ä²éѯ×Ö¶ÎÄØ£¿
¡¡¡¡desc table_name ¿ÉÒÔ²éѯ±íµÄ½á¹¹
¡¡¡¡select field_name,... from ... ¿ÉÒÔ²éѯ×ֶεÄÖµ
¡¡¡¡select * from all_tables where table_name like %
¡¡¡¡select * from all_tab_columns where table_name= ??
11. ÔõÑùµÃµ½´¥·¢Æ÷¡¢¹ý³Ì¡¢º¯ÊýµÄ´´½¨½Å±¾£¿
¡¡¡¡desc user_source
¡¡¡¡user_triggers
12. ÔõÑù¼ÆËãÒ»¸ö±íÕ¼ÓõĿռäµÄ´óС£¿


Ïà¹ØÎĵµ£º

oracleÁ¬½ÓÔ¶³ÌÊý¾Ý¿â

D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42 ......

ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ

ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ
 
MKing
2010-3-8
 
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 δÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
 
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ ......

¿ìËÙɾ³ýoracleÖØ¸´¼Ç¼


×ܽáÁËÒ»ÏÂɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¬ÒÔ¼°Ã¿ÖÖ·½·¨µÄÓÅȱµã¡£
¼ÙÉè±íÃûΪTbl£¬±íÖÐÓÐÈýÁÐcol1£¬col2£¬col3£¬ÆäÖÐcol1£¬col2ÊÇÖ÷¼ü£¬²¢ÇÒ£¬col1£¬col2ÉϼÓÁËË÷Òý¡£
1¡¢Í¨¹ý´´½¨ÁÙʱ±í
¿ÉÒÔ°ÑÊý¾ÝÏȵ¼Èëµ½Ò»¸öÁÙʱ±íÖУ¬È»ºóɾ³ýÔ­±íµÄÊý¾Ý£¬ÔÙ°ÑÊý¾Ýµ¼»ØÔ­±í£¬SQLÓï¾äÈçÏ£º
creat table tbl_tmp (select distinct* from tb ......

ORACLE 10 (¸¶Ê×ê¿)ѧϰ±Ê¼Ç µÚ2½Ú ÃüÁî¡£

ORACLE 10 ѧϰ±Ê¼Ç-µÚ2½Ú-ÃüÁî¡£
1. inner join / left join/ right join / full join
select a.dname, b.ename from dept a, emp b where a.deptno=b.deptno and a.deptno=10;
select a.dname, b.ename from dept a inner join emp b
on a.deptno=b.deptno and a.deptno=10;
select dname,ename from dept natural ......

oracle ֮ϵͳ±í µãµÎ »ýÀÛ

²é¿´ÕýÔÚÖ´ÐеÄsqlÓï¾ä
SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece;
²¶×½ÔËÐкܾõÄSQL
 select username,sid,opname, round(sofar*100 / totalwork,0) || '%' as progress, time_remaining,sql_text from v$session_longops , v$ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ