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

ÔÚoracleÖиıä×Ö¶ÎÔÚ±íÖеÄ˳Ðò

1.ÒÔsysÓû§µÇ¼oracle
2.²éÕÒÄãÒª¸ü¸ÄµÄ±í£¬ÎÒÃÇ“TEST”ÖеēAAA”±íΪÁУ¬×¢Ò⣬ÔÚoracleÖУ¬±íºÍ¿Õ¼ä¶¼ÊÇÒÔ´óд×ÖĸÏÔʾµÄ£¬ËùÒÔÕâÀï¶¼ÒªÓôó×Ö×Öĸ
Ö´ÐÐ
select object_id from all_objects where owner='TEST' and object_name='AAA';
»áµÃµ½Ò»¸öobject_id,Õâ¾ÍÊÇÎÒÃÇÐèÒª¸ü¸Ä±íµÄid£¬ÎÒÃÇÒÔ38370À´±íʾ
3.²é¿´“AAA”±íÖеÄ×Ö¶ÎÃûºÍÐòºÅ
Ö´ÐÐ
select obj#,col#,name from sys.col$ where obj#=38370;
4.Ð޸ēID”×ֶεÄÐòºÅΪ2
update sys.col$ set col#=2 where obj#=38370 and name='ID';
5.±£´æÊý¾Ý
ÕâÑùÐòºÅ¾Í¸Ä¹ýÀ´ÁË¡£
×£Äã³É¹¦£¡


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracle Stream ÅäÖÃ

Oracle  Stream ÅäÖÃ
»·¾³£º
OS:Redhat Linux
Oracle 10.2.0.4
source:TEST
destnation:STANDBY
==×¼±¸==
1.¹éµµÈÕÖ¾ÅäÖãº
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival  &nbs ......

ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ£¨×ª£©

ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ
 OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
 
Ö´Ðл·¾ ......

ORACLE Schema µÄÀí½â

¿´À´ÓеÄÈË»¹ÊǶÔschemaµÄÕæÕýº¬Ò岻̫Àí½â£¬ÏÖÔÚÎÒÔÙ´ÎÕûÀíÁËһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵ͍Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in ......

windows7 °²×°Oracle 10g¿Í»§¶Ë

ÕâÁ½ÌìÔÚwindows7Éϰ²×°OracleÅöµ½Á˵ãÎÊÌâ,Ê×ÏÈÄÃOracle 10g32λµÄ°²×°°üÈ¥×°£¬½á¹ûÒ»Çж¼Õý³££¬PL/SQLÁ¬½Ó·þÎñÆ÷Êý¾Ý¿âÕý³££¬
µ«ÊÇÖ´ÐÐÎҵijÌÐòʱ×ÜÊDZ¨ÎÞ·¨½âÎöÁ¬½Ó±êʶ·û¡£¡£ºóÀ´ÓÐͬÊÂ˵¿ÉÄÜÊÇwindows7 ÊÇ64λµÄϵͳµÄÔ­Òò¡£½ÓמÍÏÂÔØÁË64λµÄOracle
10g °æ±¾µÄ¡£¡£µ«ÔÚ°²×°Ê±£¬Ìáʾϵͳ²Ù×÷°æ±¾¹ý¸ß£ºÖ»Ö§³Ö4.1£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ