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

oracleÇ¨ÒÆ - Oracle / »ù´¡ºÍ¹ÜÀí

oracle°æ±¾ÊÇ10.2 .0.1.0ÏȰÑÒÔǰµÄÄǸö¿ª·¢·þÎñÆ÷½øÐÐÉý¼¶¡£»»¸öеķþÎñÆ÷¡£ÏÖÔÚÊý¾Ý¿âÀïÃæµÄÊý¾ÝÔõÃ´Ç¨ÒÆµ½Ð·þÎñÆ÷¡£Ï£ÍûÓÐÕâ·½ÃæµÄ×ÊÁÏ»ò¸øÐ©Ìáʾ¡£Ð»Ð»´ó¼Ò¡£

²»¶®....·¹ý

. ÔÚеķþÎñÆ÷Éϰ²×°ºÃÊý¾Ý¿â£¬½¨ºÃÏà¹ØÓû§ºÍ±í¿Õ¼ä£¬ÊÇоÉÊý¾Ý¿âµÄ±í¿Õ¼äÒ»ÖÂ

Èç¹û²»½¨Á¢µÄ»°,ÊDz»ÊǶ¼µ¼µ½systemÏÂÁË?

expdp/impdp

-- Èç¹ûÁ½·þÎñÆ÷µÄ°æ±¾Ïàͬ(²Ù×÷ϵͳλÊýÏàͬ£º¶¼ÊÇ32λ»òÕß64λ)
-- ÇÒSIDÒ²Ò»ÑùµÄ»°

-- ¹Ø±ÕÊý¾Ý¿â(Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿â) £ºÖ±½Ócopy ËùÓеÄÊý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢³õʼ»¯²ÎÊýÎļþµ½ÆäÏàÓ¦µÄλÖü´¿É!

-- Èç¹ûÁ½·þÎñÆ÷µÄ²Ù×÷ϵͳ°æ±¾Ïàͬ(²Ù×÷ϵͳλÊýÏàͬ£º¶¼ÊÇ32λ»òÕß64λ)
-- ÇÒSIDÒ²Ò»ÑùµÄ»°

-- ¹Ø±ÕÊý¾Ý¿â(Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿â) £ºÖ±½Ócopy ËùÓеÄÊý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢³õʼ»¯²ÎÊýÎļþµ½ÆäÏàÓ¦µÄλÖü´¿É!

-- Èç¹ûÁ½·þÎñÆ÷µÄ°æ±¾Ïàͬ(²Ù×÷ϵͳλÊýÏàͬ£º¶¼ÊÇ32λ»òÕß64λ)
-- ÇÒSIDÒ»Ñù£¬ÇÒÊý¾Ý¿âµÄ°²×°Â·¾¶Ò²Ò»ÑùµÄ»°

-- ¹Ø±ÕÊý¾Ý¿â(Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿â) £ºÖ±½Ócopy ËùÓеÄÊý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢³õʼ»¯²ÎÊýÎļþµ½ÆäÏàÓ¦µÄλÖü´¿É!

ÒýÓÃ
¿ÉÒÔʹÓà exp/imp »òÕß expdp/impdp
1. ÏȽ«Êý¾Ý¿âµ¼³ö
2. ÔÚеķþÎñÆ÷Éϰ²×°ºÃÊý¾Ý¿â£¬½¨ºÃÏà¹ØÓû§ºÍ±í¿Õ¼ä£¬ÊÇоÉÊý¾Ý¿âµÄ±í¿Õ¼äÒ»ÖÂ
3. ½«Êý¾Ýimp
4. ¼ì²éÓÐÎÞÎÞЧ¶ÔÏó£¬ÓоͱàÒëһϣ¬Ã»ÓоÍokÁË¡£


²Î¿¼£º
ORACLE Êý¾Ý¿âÂß¼­±¸·Ý ¼òµ¥ EXP/IMP
http://blog.csdn.net/tianlesoftware/arch¡­¡­


ÕýºÃÒªÓã¡


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

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

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

¸ß·ÖÇó½âOracleÊý¾Ý¿âµÄÁéÒìʼþ - Oracle / ¿ª·¢

½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:

update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......

oracle¹²ÏíÄÚ´æÎÊÌâ - Oracle / ¿ª·¢

java.sql.SQLException: ORA-04031: unable to allocate 26416 bytes of shared memory ("shared pool","SELECT * from ( SELECT rownu...","Typecheck heap","qry_text : qcpis ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ