ORACLEµ¼Èëµ¼³öÃüÁî½âÎö
±¾ÎĶÔOracleÊý¾ÝµÄµ¼Èëµ¼³ö imp ,exp Á½¸öÃüÁî½øÐÐÁ˽éÉÜ, ²¢¶ÔÆäÏàÓ¦µÄ²ÎÊý½øÐÐÁË˵Ã÷,È»ºóͨ¹ýһЩʾÀý½øÐÐÑÝÁ·,¼ÓÉîÀí½â.
ÎÄÕÂ×îºó¶ÔÔËÓÃÕâÁ½¸öÃüÁî¿ÉÄܳöÏÖµÄÎÊÌâ(ÈçȨÏÞ²»¹»,²»Í¬oracle°æ±¾)½øÐÐÁË̽ÌÖ,²¢Ìá³öÁËÏàÓ¦µÄ½â¾ö·½°¸;
±¾ÎIJ¿·ÖÄÚÈÝժ¼×ÔÍøÂç,¸ÐлÍøÓѵľÑé×ܽá;
Ò».˵Ã÷
oracle µÄexp/impÃüÁîÓÃÓÚʵÏÖ¶ÔÊý¾Ý¿âµÄµ¼³ö/µ¼Èë²Ù×÷;
expÃüÁîÓÃÓÚ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öÖÁ±¾µØ,Éú³ÉdmpÎļþ;
impÃüÁîÓÃÓڰѱ¾µØµÄÊý¾Ý¿âdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶³ÌµÄOracleÊý¾Ý¿âÖС£
¶þ.Óï·¨
¿ÉÒÔͨ¹ýÔÚÃüÁîÐÐÊäÈë imp help=y »ñÈ¡impµÄÓï·¨ÐÅÏ¢:
=============================================================================
C:\Documents and Settings\auduser>imp help=y
Import: Release 9.0.1.1.1 - Production on ÐÇÆÚ¶þ 5ÔÂ 20 18:21:57 2008
(c) Copyright 2001 Oracle Corporation. All rights reserved.
¿ÉÒÔͨ¹ýÊäÈë IMP ÃüÁîºÍÄúµÄÓû§Ãû/¿ÚÁî
ºó½ÓÓû§Ãû/¿ÚÁîµÄÃüÁî:
Àý³Ì: IMP SCOTT/TIGER
»òÕß, ¿ÉÒÔͨ¹ýÊäÈë IMP ÃüÁîºÍ¸÷ÖÖ²ÎÊýÀ´¿ØÖÆ“µ¼Èë”
°´ÕÕ²»Í¬²ÎÊý¡£ÒªÖ¸¶¨²ÎÊý£¬Äú¿ÉÒÔʹÓùؼü×Ö:
¸ñʽ: IMP KEYWORD=value »ò KEYWORD=(value1,value2,...,vlaueN)
Àý³Ì: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N
»ò TABLES=(T1: P1,T1: P2)£¬Èç¹û T1 ÊÇ·ÖÇø±í
USERID ±ØÐëÊÇÃüÁîÐÐÖеĵÚÒ»¸ö²ÎÊý¡£
¹Ø¼ü×Ö˵Ã÷£¨Ä¬ÈÏ£© ¹Ø¼ü×Ö ËµÃ÷£¨Ä¬ÈÏ£©
--------------------------------------------------------------------------
USERID Óû§Ãû/¿ÚÁî FULL µ¼ÈëÕû¸öÎļþ (N)
BUFFER Êý¾Ý»º³åÇø´óС fromUSER ËùÓÐÈËÓû§ÃûÁбí
FILE ÊäÈëÎļþ (EXPDAT.DMP) TOUSER Óû§ÃûÁбí
SHOW Ö»ÁгöÎļþÄÚÈÝ (N) TABLES ±íÃûÁбí
IGNORE ºöÂÔ´´½¨´íÎó (N) RECORDLENGTH IO ¼Ç¼µÄ³¤¶È
GRAN
Ïà¹ØÎĵµ£º
1£ºmapinfoµÄtab¸ñʽÊý¾Ý£¬µ¼Èëµ½oracle spatial
´ò¿ªmapinfo £¬
µã»÷¹¤¾ß---¹¤¾ß¹ÜÀíÆ÷
¹´Ñ¡easyloader
´ò¿ªeasyloader
ÔÚ¹¤¾ß²Ëµ¥ÉϾͿÉÒÔ¿´µ½easyloader
µã»÷odbc
µã»÷»úÆ÷Êý¾ÝÔ´£ºÏÂÒ»²½
Ñ¡Ôñoralce
Êý¾ÝÔ´Ãû³Æ£º×îºÃ¶¼oracle sidÒ»Ñù
ÃèÊö¿ÉÒÔ²»Ð´
Óû§Ãû³Æ£ºoracle ......
create or replace procedure inserttestdata
(
v_count in number,
v_startuserid in varchar2,
v_returnval out number )
as
v_opertime   ......
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
ora-38301´íÎó,»ØÊÕÕ¾
Ç°¼¸ÌìÓÐͬʸæËßÎÒ£¬ÓÐ̨·þÎñÆ÷Éϵıí¿Õ¼äÎÞ·¨É¾³ý£¬ÈÃÎÒ¿´¿´¡£µÇ¼µ½·þÎñÆ÷£¬É¾³ý±í¿Õ¼ä£¬Êý¾Ý¿âͬʱ±¨ora-00604ºÍora-38301´íÎó¡£Æð³õÒÔΪÊÇÓÐÊý¾Ý¿â¶ÔÏó±»Ëø¶¨£¬ÖØÆôÊý¾Ý¿âºó£¬·¢ÏÖ»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£Googleºó·¢ÏÖ¿ÉÄÜÓë10gµÄÒ»¸öÐÂÌØÐÔ»ØÊÕÕ¾Óйأ¬Çå¿Õ»ØÊÕÕ¾purge recyclebinºó£¬½øÐÐɾ³ý»¹ÊDZ ......
µ±OracleµÄ¶à¸ö´æ´¢¹ý³Ì¶¼Ê¹Óù«¹²µÄ³£Á¿Ê±£¬ÎÒÃÇ¿ÉÒÔ½¨Ò»¸öרÃŵÄpackageÓÃÀ´¹ÜÀíËùÓеij£Á¿¡£¶¨ÒåµÄʾÀý´óÖÂÈçÏ£º¡¡
create or replace package GLOBAL_CONSTANT is
/*ÊýÖµÀà³£Á¿*/
/*±ÈÂÊ*/
rate_tax CONSTANT NUMBER := 1.17; -- Ë°ÂÊ   ......