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

oracle»·¾³±äÁ¿ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ¿ÉÒÔÔËÐÐsqlplus£¬µ«ÎÒÔÚshell½Å±¾ÀïдÉÏexport ORACLE_HOME=/oracle/products/10.2/dbÕâ¾ä£¬ÔÚÖ´ÐÐÕâ¸ösh½Å±¾¾Í±¨´íÁË£º
Error 6 initializing SQL*Plus
Message file sql<lang.1>msb not found
SP2-0750:You may need to set ORACLE_HOME to your Oracle software directory
ÎÒ×Ô¼ºµÄ.bash_profileÀïдµÄÊÇexport ORACLE_HOME=/oracle/products/10.2/db£¬
ÎÒ¿´/home/oracleÀïµÄ.bash_profileÎļþдµÄexport ORACLE_HOME=/oracle/products/us11/10db,ºÍÎÒ»·¾³±äÁ¿ÀïÉèÖõIJ»Ò»Ñù£¬ÎÒÒ²Ð޸IJ»ÁËÕâ¸öÎļþ£¬¾Í°Ñ×Ô¼ºÓû§ÏµÄ.bash_profileÀïµÄORACLE_HOME¸Ä³É=/oracle/products/us11/10dbÕâ¸ö£¬µ«Ö´ÐÐsh½Å±¾»¹ÊDZ¨ÄǸö´íÎó£¬Çó¸ßÊÖ½â¾ö£¡
¸ÄÁË.bash_profileÖ®ºó£¬µÃsourceһϡ£»òÕßÔٵǼһϲÅÓÐЧ¡£


ÕÒ²»µ½Îļþ£¬µ±Ç°ÊÇʲôÓû§£¬ÓÐûȨÏÞ£¿
Message file sql<lang.1>msb not found

ÒýÓÃ
ÕÒ²»µ½Îļþ£¬µ±Ç°ÊÇʲôÓû§£¬ÓÐûȨÏÞ£¿
Message file sql<lang.1>msb not found

ÎÒ¿´Ä¿Â¼ÏÂÓÐÕâ¸öÎļþ£¬Óû§ÊÇroot´´½¨µÄ

¶¥ÆðÀ´£¬°ïæ½â¾öһϰ¡£¬ÊDz»ÊÇÁ½¸öORACLE_HOME²»Ò»Öµ¼Öµİ¡£¿

ÒýÓÃ

¶¥ÆðÀ´£¬°ïæ½â¾öһϰ¡£¬ÊDz»ÊÇÁ½¸öORACLE_HOME²»Ò»Öµ¼Öµİ¡£¿


ÏÔÈ»°¡

ÒýÓÃ
ÒýÓà 4 Â¥ xiaolengbingtian µÄ»Ø¸´:

¶¥ÆðÀ´£¬°ïæ½â¾öһϰ¡£¬ÊDz»ÊÇÁ½¸öORACLE_HOME²»Ò»Öµ¼Öµİ¡£¿


ÏÔÈ»°¡

µ«ÎÒÕâ¸öÓû§Ã»°ì·¨¸Ä/home/oracleĿ¼ÏµÄ.bash_profileÎļþ°¡£¬ÎÒÖ»ÄܸÄ×Ô¼ºÄ¿Â¼ÏµÄ.bash_prof


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

OracleÖв鿴×Ô¼º´´½¨µÄ±í - Oracle / ¸ß¼¶¼¼Êõ

Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ­´´½¨µÄ±í£¿
select tname from tab;

SQL code:

--1.sysÓû§µÇ¼
select table_name
from dba_indexes
where table_owner = 'Óû§Ãû';
--2.ËùÓÐÓû§
select * from tab; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ