oracle ±í¿Õ¼ä£¬±í¿Õ¼äÎļþ£¬±íµÄ¹ØÏµ
ÈçÌ⣬±¾ÈËÊÇoracleÐÂÊÖ£¬Çë¸ßÊÖÖ¸µãһϡ£
½¨ÒéÄãѧϰÏÂORacleÌåϵ½á¹¹°É
±í¿Õ¼äÊÇÂß¼¸ÅÄî,Ò»¸ö±í¿Õ¼ä¾ÍÊÇһƬ´ÅÅÌÇøÓò,ËûÓÖÒ»¸ö»òÕß¶à¸ö´ÅÅÌÎļþ×é³É,Ò»¸ö±í¿Õ¼ä¿ÉÒÔÈÝÄÉÐí¶à±í¡¢Ë÷Òý»òÕߴصÈ
¿ÉÒÔÕâÀïÀí½â
±í¿Õ¼ä¿ÉÒÔÓжà¸öÊý¾ÝÎļþ£¬Ò»¸öÊý¾ÝÎļþÖ»ÊôÓÚÒ»¸ö±í¿Õ¼ä£¬ÎÒ×Ô¼ºÀí½â±í¿Õ¼ä¾ÍÏ൱ÓÚsqlÒ»¸öÊý¾Ý¿â¡£
±í¿Õ¼ä¿ÉÒÔÓжà¸ö±í
±í¿Õ¼ä¶¼ÓÐÖ¸¶¨»òÕßĬÈϵÄÊý¾ÝÎļþ£¨±í¿Õ¼äÎļþ£©£¬¿ÉÒÔÓжà¸ö£¬ÓÐÁËÊý¾ÝÎļþ£¬¾Í¿ÉÒÔÔÚÀïÃæ½¨±í
±í¿Õ¼ä¡¢±íÊÇÂß¼ÉϵĸÅÄÊý¾ÝÎļþÊÇÎïÀíÉϵĸÅÄî¡£
Ò»¸ö±í¿Õ¼ä¶ÔÓ¦Ò»¸ö»ò¶à¸öÊý¾ÝÎļþ£¬¶ø±íÔòÒªÔÚij¸ö±í¿Õ¼äÖд´½¨¡£
±í¿Õ¼ä(tablespace)ÊǸöÂß¼¸ÅÄî¡£±íʾ´ÅÅ̵ÄÒ»¿éÇøÓò£¨¹íÏþµÃÔÚÄĶù£©
ûÓбí¿Õ¼äÎļþµÄ˵·¨
ÓиöÊý¾ÝÎļþ
±í¿Õ¼äÊÇÓÐÊý¾ÝÎļþ£¨datafile£©×é³ÉµÄ,ÊÇÓ²ÅÌÉÏ´æÔÚµÄÈô¸öÎļþ¡£Ò»¸ö±í¿Õ¼äÊÇÓɼ¸¸öÊý¾ÝÎļþ×é³É
..(¿ÉÒÔÀí½â£¬Êý¾ÝÎļþµÄ¿Õ¼ä¾ÍÊÇ´æ·Å±í¿Õ¼äµÄ£¡)
±í£ºÊǸö¶ÔÏ󣬱íÏÖÔÚÊý¾Ý¿âÖоÍÊÇÊý¾Ý¶Î£¬Ò»¶ÎÒ»¶Î¶ùµÄ¡£¡£´æÔÚÓÚ±í¿Õ¼äÖУ¬±ãÓÚ¹ÜÀí¡£ÎïÀíÉϾÍÊÇ´æ·ÅÔÚÊý¾ÝÎļþÖÐѽ
Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬Èô¸É¸öÊý¾ÝÎļþºÍ¶à¸ö±í£¬Ò»¸öÊý¾ÝÎļþ»òÒ»¸ö±íÖ»ÄÜÊôÓÚÒ»¸ö±í¿Õ¼ä;
Ò»¸öÊý¾ÝÎļþ°üº¬Èô¸É±í£¬Ò»¸ö±í¿É´æÔÚÓÚ¶à¸öÊý¾ÝÎļþÖУ®
ÏêϸÇë²Î¿¼ORACLEÌåϵ½á¹¹£¬ÕâÀï¼òµ¥½éÉÜ£º
±í¿Õ¼ä¡¢Êý¾ÝÎļþ¡¢¶Î¡¢¿éÈçÏÂͼËùʾ£¨ORACLEÂß¼½á¹¹Í¼£©¡£
1¡¢±í¿Õ¼äΪÂß¼¹ÜÀíÇø£¬ÊÇÒ»¸öÂß¼¸ÅÄÏ൱ÓÚÒ»¸ö´ó¼Ü×Ó£¬»òÕß˵һ¸ö²Ö¿âÄÚ²¿À´×°¶«Î÷Ò»Ñù£¬ÎÒÃÇ·½±ã¹ÜÀí¡£
2¡¢Ò»¸ö±í¿Õ¼ä¶ÎÊÇÒ»¸öʵÌåµÄ»ù±¾±êÖ¾£¨·ÖÊý¾Ý¶ÎºÍË÷Òý¶Î£©£¬»ù±¾µÈ¼ÛÓÚÒ»¸ö±í»òÕßÒ»¸öË÷Òý£¬ÈôΪ·ÖÇø±íºÍ·ÖÇøË÷Òý£¬Ò»¸ö
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......