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

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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracle Job Óï·¨ºÍʱ¼ä¼ä¸ôµÄÉ趨

³õʼ»¯Ïà¹Ø²ÎÊý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ºÍTomcat¶Ë¿Ú³åÍ»
Ô­Òò:
    Oracle 9i¿ªÊ¼£¬´´½¨Êý¾Ý¿âʱĬÈÏ°üº¬ÁËXDBÌØÐÔ¡£Ò»µ©Æô¶¯ÁËÊý¾Ý¿âºÍListener£¬Oracle XDBµÄhttp·þÎñ¾ÍÕ¼ÓÃ8080¶Ë¿Ú£¬¸ÕºÃºÍJBoss¡¢TomcatµÈĬÈ϶˿ڳåÍ»¡£
½â¾ö·½·¨
 1¡¢¸Ä¶¯tomcat¶Ë¿Ú£¬
´ò¿ªD:\Tomcat5\conf\server.xml£¬²éÕÒÈçÏÂÎı¾Î»Öãº
<!-- Def ......

Oracleϵͳ±í²éѯ

 Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£  
¡¡¡¡1¡¢Óû§£º  
¡¡¡¡¡¡select username from dba_users;  
¡¡¡¡¸Ä¿ÚÁî  
¡¡¡¡¡¡alter user spgroup identified by spgtest;   
¡¡¡¡2¡¢±í¿Õ¼ä£º  
¡¡¡¡¡¡select * from dba_data_files;&nbs ......

Oracle´æ´¢¹ý³ÌµÄÖ´ÐÐ

declare
msg varchar(1000);    --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg);   --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg);   --Êä³ö±äÁ¿
end; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ