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

28.2 OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°

28.2  OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°
Óû§¿ÉÒÔͨ¹ýOracleµÄ¹Ù·½ÍøÕ¾ÏÂÔØµ½×îеÄOracleÊý¾Ý¿â²úÆ·µÄÈí¼þ°²×°°ü£¬ÔÚ°²×°Oracle 11gǰÐèÒª¼ì²éϵͳµÄÈíÓ²¼þ»·¾³ÊÇ·ñ·ûºÏ°²×°ÒªÇó¡£Oracle 11gÌṩͼÐλ¯µÄ°²×°³ÌÐò½çÃæ£¬Óû§¿ÉÒÔͨ¹ýµ¥»÷Êó±êÍê³ÉOracleµÄ°²×°¡£


Ïà¹ØÎĵµ£º

oracle ¿ìËÙ»Ö¸´±íɾ³ýµÄijÐÐÊý¾Ý

ÇëÎÊÏÂ,ÎÒɾ³ý±íµÄijЩÊý¾Ý,ÈçºÎ°ÑËüÉÁ»ØÀ´Ñ½? 20·ÖÖÓÄÚ²»¹ý¶Ô¸Ã±íÓɲåÈëÁËЩÊý¾Ý
¸ù¾ÝscnºÅÀ´²éѯ
select a, b, c, versions_xid, versions_starttime, versions_endtime,
versions_startscn,versions_endscn,versions_operation
  from test versions between scn 339493 and 339635
¸ù¾Ýʱ¼äÒ²¿ÉÒÔ
from te ......

[×ªÔØ]oracleÖв鿴Óû§È¨ÏÞ

1.²é¿´ËùÓÐÓû§£º
  select * from dba_users;
  select * from all_users;
  select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ(Ö±½Ó¸³Öµ¸øÓû§»ò½ÇÉ«µÄϵͳȨÏÞ)£º
  select * from dba_sys_privs;
  select * from user_sys_privs;
3.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óû§ÓµÓеĽÇÉ«)Ëù°üº¬µÄÈ ......

oracle ¾«¼ò¿Í»§¶Ë Óë ·þÎñÆ÷¶Ë °²×°

ÏÈ×°ÁËÊý¾Ý¿â£¬ÓÃnetµ÷ÊÔµÄʱºòûÓÐÎÊÌ⣬µ«ÊÇÉú³ÉÍøÕ¾ºó£¬ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÌáʾ˵¿Í»§¶ËµÄ°æ±¾Ì«µÍ£¨Òâ˼¾ÍÊÇÕâ¸ö£©£¬ºóÓÖ×°ÁËÒ»¸ö9iµÄ¿Í»§¶Ë£¬Ö®ºó¾Í°ÑÏà¹Ø·þÎñ¸Ä³ÉÊÖ¶¯£¬NÌìÖ®ºó·¢ÏÖÊý¾Ý¿â²»ÄÜÕý³£Æô¶¯¡£
Message file sp1<lang>.msb not found  SP2-0750: You may need to set ORACLE_HOME to your Oracl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ