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

ORACLE Êý¾Ý¿â·ÖÀë - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?


ûÓÐÁªÏµµÄ

exp, imp



ÎÒÒª°ÑÆäÖеÄÁ½¸ö·Åµ½ÁíÍâµÄ·þÎñÆ÷ÉÏ£¬Í¬Ê±°ÑÊý¾ÝʲôµÄ¶¼²»Òª£¬Ï£ÍûÄܹ»Ìá¸ß·þÎñÆ÷ÐÔÄÜ¡£

ûŪ¶®Ê²Ã´Òâ˼°¡

ÆäËûÒªÇóÄØ?Êý¾ÝÁ¿´ó²»´ó?ÒªÁª»úÇ¨ÒÆ»¹ÊÇÍÑ»úÇ¨ÒÆ?·þÎñÆ÷ϵͳÏàͬÓë·ñ?

== ¶¼ÎÞÒªÇóµÄ»°,EXP ,IMP ×îºÃÒ²×îÈÝÒ×½â¾ö............

Êý¾ÝÁ¿Ò²²»´ó£¬²»µ½2G£¬Áª»úÍÑ»úûÓÐÒªÇó¡£·þÎñÆ÷ϵͳÊÇÒ»ÑùµÄ¡£
ÏÖÔÚÎÒµÄÖ÷ÒªÎÊÌâÊÇ£¬ÈçºÎÔÚÔ­ÓзþÎñÆ÷ÉÏ£¬°ÑÁíÍâµÄÁ½¸ö¿â¸Éµô£¬¶øÁôϵIJ»ÊÜÓ°Ïì

exp,imp¾Í¿ÉÒÔÁË¡£

ÁíÍâÁ½¸ö°áǨ³öÈ¥µÄ¿â£¬ÎÒÔõô¸ÉµôËû¶ø²»ÊÜÓ°Ïì¡£·ÅÔÚÒ»ÆðÓ°ÏìÐÔÄÜ


exp,imp¾Í¿ÉÒÔÁË¡£

·Ö¿ªµÄÄ¿µÄ¾ÍÊÇÌá¸ßÐÔÄÜ
Èç¹ûËø¶¨Ò²ÄÜÂú×ãµÃ»°£¬µ±È»Ò²¿ÉÒÔ
ÎÒµÄÏë·¨ÊÇɾ³ý¡£

exp userid=system/<system_password>@tnsname owner=user1 file=user1.dmp
exp userid=system/<system_password>@tnsname owner=user2 file=user2.dmp
exp userid=system/<system_password>@tnsname owner=user3 file=user3.dmp
ÔÚ¸÷×Ô¶ÔÓ¦µÄϵͳÖд´½¨Óû§ºÍ±í¿Õ¼ä£¬ÊÚȨ£¬ÔÙ·Ö±ðimp
imp userid=system/<system_password>@tnsname fromuser=user1 touser=user1 file=user1.dmp

Ïëɾ³ý¾Ídrop user
ÏëÇ¨ÒÆ¾Íexp/imp »òÕßrman

Ëø¶¨Óû§´ú¼Û×îС£¬·çÏÕ×îС

1¡¢°´Óû§·Ö±ðµ¼³öexp£¨µ¼³öʱʹÓÃowner²ÎÊýÖ¸¶¨µ¼³öÓû§£¬Ã¿´ÎÖ¸¶¨Ò»¸öÓû§£¬µ¼³ÉÈý¸öÊý¾ÝÎļþ£©£»
2¡¢ÔÚÏàÓ¦µÄÊý¾Ý¿âÉϽ¨Á¢¶ÔÓ¦µÄ±í¿Õ¼äºÍÓû§


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ