oracleÊý¾Ý¿â±í½á¹¹µ¼³ö
½ñÌìÓÐͬÊ´òµç»°ÒªÇóÒª°Ñoracle¿âÀïµÄÒ»ÕűíµÄ¶¨Òåµ¼³ö¸ösqlÎļþ£¬µ±Ê±µÄµÚÒ»·´Ó¦¾ÍÊÇÒª½ÌËûÓÃexp/impÀ´»ñµÃ±í½á¹¹¶¨ÒåÎļþ£¬Ôڵ绰ÀïÃæ˵ÁË°ëÌ컹ÊÇûÄ̻ܽáËû£¬Ö»ºÃÅÜÁËÒ»ÌË»ú·¿¡£Â·ÉϾÍÔÚÏ룬oracleÕæÊÇÌÖÑᣬΪʲô²»ÔÚÆóÒµ¹ÜÀíÆ÷ÀïÖ±½Ó¼ÓÉϸö±í½á¹¹µ¼³öµÄÑ¡Ï»¹Òªº¦ÎÒÕâôÅÜÒ»ÌË£¬ÕæÊÇ@@#!!@!#@@@@
ÎÊÁËÏÂÒªµ¼³öÄÄÕűíÒÔºó£¬ÏÈÓÃexpÖ»µ¼³ö¸ÃÕűíµÄ½á¹¹¶¨Òå
exp username/password rows=n file=export.dmp tables=XXXXXXXXX
È»ºóÓÃimpÉú³É±í¶¨ÒåÎļþ
imp username/password rows=n file=export.dmp indexfile=schema.sql
½á¹û³öÀ´ÁË£¬¿ÉÊÇ»¹ÊǺܲ»Ë¬£¬ÓÚÊǾÍÔÚoemÀïÃæµ½´¦µãÀ´µãÈ¥£¬¿´¿´ÊDz»ÊÇÓÐÎÒÊ詵ĵط½¿ÉÒÔÍê³ÉÕâ¸ö¼òµ¥µÄÈÎÎñ£¬»¹ÊDz»ÐС£ÉúÆø£¬Õýµ±Ïë·ÅÆúµÄʱºò£¬ºöÈ»ÏëÆðoemÀïÃæÊÇ¿ÉÒÔÑ¡Ò»Õűí¸ñ£¬È»ºó´´½¨Ïàͬ½á¹¹µÄÒ»ÕűíµÄ¡£¸Ï½ôµãÁ˼¸Ï£¬È»ºóÒ»µãµ×ϵÄÏÔʾsql£¬±í¶¨ÒåµÄsqlÓï¾ä³öÀ´ÁË£¬Ö±½ÓÔε¹£¬ÊÇΪ¼ÇÖ®¡£
¸½Â¼£º
ÒÔÏÂ×ÊÁÏÀ´Ô´itpub
¸Õ²Å²éÁËÏ£¬oracleÀïÃæÊÇÓж¨ÒåDMBS_METADATA.GET_DLLÕâ¸ö´æ´¢¹ý³ÌÀ´»ñÈ¡±í½á¹¹µÄsqlÓï¾äµÄ£¬Ê¹Ó÷½·¨ÈçÏÂ
//»ñÈ¡Ò»¸öSCHEMAϵÄËùÓн¨±íºÍ½¨Ë÷ÒýµÄÓï·¨£¬ÒÔscottΪÀý£º
spool portal_schema.sql
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
from USER_TABLES u;
SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
from USER_INDEXES u;
spool off;
»òÕßÖ±½Ó×°Ò»¸öPL/SQL Developer£¬ÀïÃæÓÐÌṩÏà¹ØµÄÑ¡Ïî¡£
ת×Ô£ºhttp://blog.akaka.com.cn/2006/10/oracle%E6%95%B0%E6%8D%AE%E5%BA%93%E8%A1%A8%E7%BB%93%E6%9E%84%E5%AF%BC%E5%87%BA.html
///////////////////
ÓÃexpÃüÁîµ¼³ö±í½á¹¹£¬²»µ¼³ö±íÊý¾Ý¡£Ö»ÐèÔÚÃüÁîÐÐÀï¼ÓÒ»¸ö²ÎÊýrows=n¼´¿É¡£±íʾ²»µ¼³ö±íÊý¾Ý¡£Èç¹ûûÓÐtables£¬Ä¬Èϵ¼³öÈ«²¿Óû§±í
exp username/pwd@sid file=d:\data\bak.dmp owner=(user) rows=n
Èç¹ûÒªµ¼³öÌض¨¼¸¸ö±í£¬¿É¼ÓÉÏTABLES=(EMP,DEPT,MGR)£¬Ìض¨µÄ±íÃû
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ODP.NET 11gÊÇOracle¹«²¼µÄ¹©.NET³ÌÐò·ÃÎÊOracleÊý¾Ý¿âµÄADO.NET×é¼þ£¬±È΢Èí×Ô´øµÄOracle×é¼þÐÔÄܺ㬸ü¿ÉÒÔ·ÃÎÊUDT(User Defined Type)²¿À࣬Procedure£¬REFÖ®Àà¸ß¼¶OracleÌØÕ÷¡£
¡¡¡¡.NET 1.1µÄ¿Í»§¶Ë¼±ÐèµÄ¹«²¼×ÊÁÏÈç´Î£º
¡¡¡¡¡ôOracle.DataAccess.dll (odt111odp.netinÒ».x)
¡¡¡¡¡ôOraOps11.dll £¨odt111in£© ......
Ò».ÌÞ³ý±íÖÐÊý¾ÝÁ½ÖÖ²½Öè
a. delete * from My_Table;
b. truncate table My_Table;
¶þ.ÌÞ³ýÕû¸ö±í
drop table My_Table;
ºÎÒԻظ´²»Ð¡ÐÄ Drop µôµÄ±íÄØ,ʵÔò Oracle ÖÐÒ²ÓÐÏà·ÂµÄ "»ØÊÕÕ¾"
ÀýÈ粻СÐÄÌÞ³ýÁ˱í My_Table
drop table My_Table;
Õâ¸öʱ·ÖÔÙÓÃSELECT»°Óï²éѯ´Ë±íʱ£¬½«»áÌáÐѱí»òÊÓͼ²»´æÔÚ.
µ«¿ÉÒÔÓ ......
ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ
×÷Õߣº[תÌù] ³ö´¦£º
×î
½ü×öÒ»¸öJ2EEÏîÄ¿£¬ÐèÒªÔÚJSPÒ³ÃæʵÏÖ¶ÔÎļþµÄÉÏ´«ºÍÏÂÔØ¡£ºÜÔçÒÔÇ°¾ÍÖªµÀJDBCÖ§³Ö´ó¶ÔÏó£¨LOB£©µÄ´æÈ¡£¬ÒÔΪºÜÈÝÒ×£¬×öÆðÀ´²Å·¢ÏÖÎÊÌâ¶à
¶à£¬¶ÁÁËÒ»´ó¶ÑÎÄÕ£¬·´¶øûÓÐʲôͷÐ÷ÁË¡£ÕýÈçһλÍøÓÑÎÄÕÂËù½²£º“&h ......
Ê×ÏÈ´´½¨Ò»¸öË÷Òý£¬È»ºó´´½¨Ò»¸ö´¥·¢Æ÷
Ë÷ÒýµÄÃû×Ö£º SEQ_tproduct
´¥·¢Æ÷µÄÃû×Ö£º addid
±íÃû£ºtproduct
×ÔÔöÁÐÃû£ºpid
create sequence SEQ_tproduct &n ......