Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡­¡­


ÕýºÃÒªÓã¡


Ïà¹ØÎÊ´ð£º

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

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

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

oracle ´æ´¢¹ý³ÌÖÐÓ¦ÓÃÊÂÎñµÄÎÊÌâ - Oracle / ¿ª·¢

SQL code:

CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......

ÓÃibatisµ÷ÓÃoracleº¯ÊýµÄÎÊÌâ - Java / Web ¿ª·¢

oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
  p_mobileNumber in VARCHAR2,
  p_cityid out NUMBER
) Return NUMBER
IS
  p_areacode varc ......

asp.net·¢²¼Ê±£¬Oracle±¨´í - .NET¼¼Êõ / ASP.NET

1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
  vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ