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

oracle Öеĵ¼Èëµ¼³ö

exp document/document2009@document owner=document rows=y compress=y buffer=65536 feedback=100000 file=D:\document.dmp log=D:\document.log
exp whd/whd2009@whddb owner=whd rows=y compress=y buffer=65536 feedback=100000 file=D:\whd.dmp log=D:\whd.log
imp document/document2009@document fromuser=document touser=document rows=y commit=y buffer=65536 feedback=100000 file=D:\document.dmp  log=D:\document.log
imp whd/whd2009@whddb fromuser=whd  touser=whd rows=y commit=y buffer=65536 feedback=100000 file=D:\whd.dmp  log=D:\whd.log
//²é¿´Êý¾ÝÎļþ´æ´¢Î»ÖÃ
select * from dba_DATA_FILES
exp whd/whd2009@whddb66 owner=whd rows=y compress=y buffer=65536 feedback=100000 file=D:\whd.dmp log=D:\whd.log


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿â°æ±¾±äǨÀúÊ·

·1979ÄêµÄÏļ¾£¬RSI·¢²¼ÁËOracleµÚ¶þ°æ
·1983Äê3Ô£¬RSI·¢²¼ÁËOracleµÚÈý°æ
´ÓÏÖÔÚÆðOracle²úÆ·ÓÐÁËÒ»¸ö¹Ø¼üµÄÌØÐÔ:¿ÉÒÆÖ²ÐÔ
·1984Äê10Ô£¬Oracle·¢²¼Á˵Ú4°æ²úÆ·
ÕâÒ»°æÔö¼ÓÁ˶ÁÒ»ÖÂÐÔÕâ¸öÖØÒªÌØÐÔ
·1985Ä꣬Oracle·¢²¼ÁË5.0°æ
Õâ¸ö°æ±¾ËãµÃÉÏÊÇOracleÊý¾Ý¿âµÄÎȶ¨°æ±¾¡£ÕâÒ²ÊÇÊ ......

dzÎöoracleÊý¾Ý¿âµÄÓŵã


oracleÊý¾Ý¿âµÄÓŵãÒ»£º
ORACLE7.XÒÔÀ´ÒýÈëÁ˹²ÏíSQLºÍ¶àÏßË÷·þÎñÆ÷Ìåϵ½á¹¹¡£Õâ¼õÉÙÁËORACLEµÄ×ÊÔ´Õ¼Ó㬲¢ÔöÇ¿ÁËORACLEµÄÄÜÁ¦£¬Ê¹Ö®Ôڵ͵µÈíÓ²¼þƽ̨ÉÏÓýÏÉÙµÄ×ÊÔ´¾Í¿ÉÒÔÖ§³Ö¸ü¶àµÄÓû§£¬¶øÔڸߵµÆ½Ì¨ÉÏ¿ÉÒÔÖ§³Ö³É°ÙÉÏǧ¸öÓû§¡£
oracleÊý¾Ý¿âµÄÓŵã¶þ£º
ÌṩÁË»ùÓÚ½ÇÉ«(ROLE)·Ö¹¤µÄ°²È«±£ÃܹÜÀí¡£ÔÚÊý¾Ý¿â¹ÜÀí¹¦ÄÜ ......

oracleÎﻯÊÓͼ

ÎﻯÊÓͼÊÇÒ»ÖÖÌØÊâµÄÎïÀí±í£¬“Îﻯ”(Materialized)ÊÓͼÊÇÏà¶ÔÆÕͨÊÓͼ¶øÑԵġ£ÆÕͨÊÓͼÊÇÐéÄâ±í£¬Ó¦ÓõľÖÏÞÐÔ´ó£¬ÈκζÔÊÓͼµÄ²éѯ£¬Oracle¶¼Êµ¼ÊÉÏת»»ÎªÊÓͼSQLÓï¾äµÄ²éѯ¡£ÕâÑù¶ÔÕûÌå²éѯÐÔÄܵÄÌá¸ß£¬²¢Ã»ÓÐʵÖÊÉϵĺô¦¡£
    1¡¢ÎﻯÊÓͼµÄÀàÐÍ£ºON DEMAND¡¢ON COMMIT
  &n ......

ORACLEË÷Òý½éÉÜÓë¸ßÐÔÄÜSQLÓÅ»¯

ʲôÊÇË÷Òý
¡¡¡¡
¡¡¡¡Ë÷ÒýÊǽ¨Á¢ÔÚ±íµÄÒ»Áлò¶à¸öÁÐÉϵĸ¨Öú¶ÔÏó£¬Ä¿µÄÊǼӿì·ÃÎʱíÖеÄÊý¾Ý£»
¡¡¡¡
¡¡¡¡Oracle´æ´¢Ë÷ÒýµÄÊý¾Ý½á¹¹ÊÇB*Ê÷£¬Î»Í¼Ë÷ÒýÒ²ÊÇÈç´Ë£¬Ö»²»¹ýÊÇÒ¶×ӽڵ㲻ͬB*ÊýË÷Òý£»
¡¡¡¡
¡¡¡¡Ë÷ÒýÓɸù½Úµã¡¢·ÖÖ§½ÚµãºÍÒ¶×Ó½Úµã×é³É£¬Éϼ¶Ë÷Òý¿é°üº¬Ï¼¶Ë÷Òý¿éµÄË÷ÒýÊý¾Ý£¬Ò¶½Úµã°üº¬Ë÷ÒýÊý¾ÝºÍÈ·¶¨ÐÐ ......

oracleÊý¾ÝÀàÐÍ


Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ