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

oracleÔõôָ¶¨Êý¾Ý¿â

ÀàËÆsqlserver ÖеÄuse database
ÓÐÀàËÆµÄÃüÁîÂð£¿
ÁíÍ⣬oracleÖÐÓÐdboÕâ¸öÓû§°É£¬¼ÙÉèÎÒÓÃÓиöÃûΪportalµÄtablespace£¬ÔÚ¸Ãspace½¨Á¢Ò»¸ötableÃû×ÖÊÇmcyandy £¬ÄÇôÎÒ¿ÉÒÔÓÃselect * from dbo.mcyandyÀ´´úÌæselect * from portal.mcyandyÂð£¿
ÎÒ¶¥

oracleÀï±íǰ׺²»ÐèÒªtablespace£¬Ç°×ºÊDZíµÄowner¡£

ÈçÒÔAÓû§´´½¨±ítable£¬Ôò·ÃÎʸñíʱ£º
select * from table;    --×Ô¼º·ÃÎÊ×Ô¼ºµÄ±í
select * from A.table;  --ÆäËûÓû§·ÃÎʸñí

ÒýÓÃ
oracleÀï±íǰ׺²»ÐèÒªtablespace£¬Ç°×ºÊDZíµÄowner¡£

ÈçÒÔAÓû§´´½¨±ítable£¬Ôò·ÃÎʸñíʱ£º
select * from table;    --×Ô¼º·ÃÎÊ×Ô¼ºµÄ±í
select * from A.table;  --ÆäËûÓû§·ÃÎʸñí

ÄÇô¼ÙÉèÎÒÓÃPortalÓû§½¨Á¢Êý¾Ý¿âmcyandy £¬È»ºóÓÃportalµÇ¼£¬ÎÒ¿ÉÒÔÓÃselect * from dbo.mcyandyÀ´´úÌæselect * from portal.mcyandyÂð£¿


ÀàËÆsqlserver ÖеÄuse database
ÓÐÀàËÆµÄÃüÁîÂð£¿

ûÓÐÕâÑùµÄÃüÁî°É

¶¥£¡


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

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 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ