OracleÓÃimpºÍexpʵÏÖÊý¾ÝµÄµ¼ÈëºÍµ¼³ö
ImpºÍExp
ÃüÁîÏê½â:
Exp
µ¼³ö
ģʽ:
Fullģʽ---µ¼³ö
Õû¸öÊý¾Ý¿â
Userģʽ---µ¼³ö
Ö¸¶¨µÄÓû§
Tableģʽ—µ¼³ö
Ö¸¶¨µÄ±í
Tablespaceģʽ—µ¼³ö
±í
¿Õ¼ä
Exp
µ¼³ö
²ÎÊý:
OWNERÖ¸¶¨Òªµ¼³ö
µÄÓû§Áбí
FULL=y±íʾҪµ¼³ö
Õû¸öÊý¾Ý¿â
TablesÖ¸¶¨Òªµ¼³ö
µÄ±í
TablepacesÖ¸¶¨Òªµ¼³ö
µÄ±í
¿Õ¼ä
ROWS=y±íʾµ¼³ö
±í
Êý¾Ý
,·ñÔòÖ»µ¼³ö
±í
µÄ½á¹¹.
HELP=Y±íʾҪ»ñÈ¡°ïÖú
IndexsÖ¸¶¨ÊÇ·ñµ¼³ö
Ë÷Òý
Grants±íʾÊÇ·ñµ¼³ö
ÊÚȨ
QUERYÖ¸¶¨²éѯÌõ¼þ,ÔÊÐíÓû§µ¼³ö
±í
µÄÒ»²¿·ÖÊý¾Ý
TriggersÖ¸¶¨ÊÇ·ñµ¼³ö
´¥·¢Æ÷
1.Full
ģʽ:
°ÑÊý¾Ý¿âorclÍêÈ«µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
system/pafirc@orcl file=e:\ pafirc.dmp full=y
2.User
ģʽ:
°Ñsystem,pafircÓû§µÄ±í
µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp owner=(system, pafirc)
3.Table
ģʽ:
°Ñ±í
tab_projµ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp tables=(tab_proj)
4.
±¸·Ý±í
ÖеIJ¿·ÖÊý¾Ý
°Ñ±í
tab_projÖеÄ×Ö¶ÎbudgetСÓÚ500000Êý¾Ý
µ¼³ö
µ½D:\pafirc.dmpÖÐ,
exp
pafirc/pafirc@orcl file=e:\ pafirc.dmp tables=(tab_proj) query=\" where budget<500000\"
ÈçÏÂͼ:
clip_image014
Imp
ÃüÁîÊý¾Ý
µÄµ¼Èë
ÀàËÆexp
,Ö»Òª°Ñexp
»»³Éimp¾Í¿ÉÒÔ,Èç¹ûµ¼Èë³É¹¦,»áÓÐÏÂÃæµÄÌáʾ:
clip_image016
clip_image018
Èý.´´½¨Óû§¼°ÊÚȨ
1.´´½¨Óû§:
CREATE USER PAFIRC
IDENTIFIED BY PAFIRC
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
2.ÊÚÓèÓû§È¨ÏÞ
GRANT DBA TO PAFIRC WITH ADMIN OPTION;
GRANT CONNECT TO PAFIRC WITH ADMIN OPTION;
GRANT RESOURCE TO PAFIRC WITH ADMIN OPTION;
GRANT DBA TO PAFIRC WITH ADMIN OPTION;
ALTER USER PAFIRC DEFAULT ROLE DBA,CONNECT,RESOURCE;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄÖµ¡ ......
OracleºÍTomcat¶Ë¿Ú³åÍ»
ÔÒò:
Oracle 9i¿ªÊ¼£¬´´½¨Êý¾Ý¿âʱĬÈÏ°üº¬ÁËXDBÌØÐÔ¡£Ò»µ©Æô¶¯ÁËÊý¾Ý¿âºÍListener£¬Oracle XDBµÄhttp·þÎñ¾ÍÕ¼ÓÃ8080¶Ë¿Ú£¬¸ÕºÃºÍJBoss¡¢TomcatµÈĬÈ϶˿ڳåÍ»¡£
½â¾ö·½·¨
1¡¢¸Ä¶¯tomcat¶Ë¿Ú£¬
´ò¿ªD:\Tomcat5\conf\server.xml£¬²éÕÒÈçÏÂÎı¾Î»Öãº
<!-- Def ......
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;&nbs ......
declare
msg varchar(1000); --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg); --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg); --Êä³ö±äÁ¿
end; ......