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

OracleÊý¾Ý¿âimpºÍexpµÄʹÓá¾×ª¡¿


1.µ¼ÈëÊý¾ÝÃüÁimp userid=fkprod/fkprod full=y file=xxx.dmp
2.µ¼³öÊý¾Ý¿â¶ÔÏóÃüÁ
ʹÓÃtools--->export user objectÖ»Äܵ¼³öÊý¾Ý±í½Å±¾²»ÄÜ´ø³öÊý¾Ý,
»òÕßʹÓÃexp user/pwd file=/dir/xxx.dmp log=xxx.log full=y commit=y ignore=y
×¢Ò⣺Èç¹ûÄãÒªÔ¶³ÌµÇ¼µ½Êý¾Ý¿â·þÎñÆ÷µ¼³ö£¬¿ÉÒÔÔÚ±¾µØSQLPLUS×öÈçÏÂÃüÁ
>1.µÚÒ»ÖÖ·½·¨ÔÚSQLPULS£º
conn user/pwd@schema
$exp user/pwd file=/dir/xxx.dmp log=xxx.log full=y commit=y ignore=y
>2.ÔÚwindows²Ù×÷ϵͳµÄcmd ÃüÁîÐд°¿ÚÖÐ,Ö±½ÓʹÓÃimpºÍexp¼´¿É.
>3.ÔÚlinuxÏÂ, ÒÔoracleÓû§µÇ¼,ÔÚÖÕ¶ËÖÐÖ±½ÓÊäÈëimpºÍexp¾Í¿ÉÒÔ.
3.ɾ³ýÓû§ÓëÆä¶ÔÏó£ºdrop user username cascade
4. ¸øÓû§·ÖÅä½ÇÉ«£ºGRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
   DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
      DBA,CONNECT,RESOURCE,CREATE SESSION  TO Óû§Ãû
5.´´½¨Ò»¸öÓû§£ºcreate user "XXXX" identified by "XXXX"  ×¢Ò⣺ÕâÀïµÄÓû§ÃûºÍÃÜÂëÒ»¶¨ÒªÓôóд
¸ü¶àµÄʹÓÃÇë²Î¿¼Ò»Ï¼¸ÖÖ·½Ê½
ÒÔÏÂÈýÖÖ·½Ê½£º
£¨1£©½»»¥Ê½·½Ê½
$ exp        //  È»ºó°´ÌáʾÊäÈëËùÐèÒªµÄ²ÎÊý
£¨2£©ÃüÁîÐз½Ê½
$ exp user/pwd@dbname file=/oracle/test.dmp full=y    //  ÃüÁîÐÐÖÐÊäÈëËùÐèµÄ²ÎÊý
 
£¨3£©²ÎÊýÎļþ·½Ê½
$ exp parfile=username.par    //  ÔÚ²ÎÊýÎļþÖÐÊäÈëËùÐèµÄ²ÎÊý
²ÎÊýÎļþ username.par ÄÚÈÝ userid=username/userpassword buffer=8192000
compress=n grants=y
file=/oracle/test.dmp full=y
 
3.  ÈýÖÖģʽ
 
£¨1£©±í·½Ê½£¬½«Ö¸¶¨±íµÄÊý¾Ýµ¼³ö/µ¼Èë¡£
µ¼³ö£º
µ¼³öÒ»ÕÅ»ò¼¸ÕÅ±í£º
$ exp user/pwd file=/dir/xxx.dmp log=xxx.log tables=table1,table2
µ¼³öijÕűíµÄ²¿·ÖÊý¾Ý
$ exp user/pwd file=/dir/xxx.dmp log=xxx.log tables=table1 query=\”where col1=\’…\’
and col2 \<…\”
µ¼È룺
µ¼ÈëÒ»ÕÅ»ò¼¸Õűí
$  imp  user/pwd  file=/dir/xxx.dmp  log=xxx.log  tables=table1,table2  fromuser=dbuser touser=dbuser2 commit=y ignore=y
 
£¨2£©Óû§·½Ê½£¬½«Ö¸¶¨Óû§µÄËùÓжÔÏó¼°Êý¾Ýµ¼³ö/µ¼


Ïà¹ØÎĵµ£º

Oracle wait problems and potential solutions

Wait Problem Potential Fix Sequential Read Indicates many index reads—tune the code (especially joins) Scattered Read Indicates many full table scans—tune the code; cache small tables ......

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â


    Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Î ......

ORACLEµÄJOB´´½¨

ORACLEµÄJOB´´½¨£¬¿ÉϧµÄÊDz»ÄܸÄÃû£¬Ö»ÄÜÊÇÊý×ÖµÄÃû×Ö¡£
DECLARE X NUMBER;
BEGIN
  SYS.DBMS_JOB.SUBMIT
  ( job       => X
   ,what      => 'compile_invalid_object;'
   ,next_date => to_date('20-04-2010 ......

Oracle´Ó·Ç¹éµµÄ£Ê½±ä³É¹éµµÄ£Ê½

http://www.cuijie.net.cn/?cat=6
¸ü¸ÄÊý¾Ý¿âµÄ¹éµµÄ£Ê½ÐèÒªÖØÐÂÆô¶¯Êý¾Ý¿â£¬ÔÚmountģʽÏÂÐ޸쬼òÒª²½Öè
1   ÒÔshutdown immediate ·½Ê½¹Ø±ÕÊý¾Ý¿â
2  Æô¶¯ÊµÀýµ½mount״̬
3  ¸ü¸ÄÔËÐÐģʽ²¢´ò¿ªÊý¾Ý¿â
²Ù×÷²½Ö裺
1   µÇ¼Êý¾Ý¿â²é¿´Êý¾Ý¿âµÄ¹éµµ×´Ì¬
     S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ