Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 waits event:DB File Sequential Read

The DB File Sequential Read wait event generally indicates a single block read (an index read,
for example). A large number could indicate poor joining orders of tables or unselective indexing.
This number will certainly be large (normally) for a high-transaction, well-tuned system. You ......

linuxÉÏʹÓÃrlwrap ½â¾öoracle¿ÉÒÔÉÏϼü²é¿´ÃüÁî

linux ÉϵÄoracle sqlplus ²»ÄÜÀûÓà ÉÏ, Ï ¼üÀ´²é¿´ÃüÁËÑË÷µ½½â¾öÎÊÌâµÄ°ì·¨£¬ÕûÀíÈçÏÂ
°²×°Èí¼þrlwrap¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣬¸ÃÈí¼þÊÇÓÃcдµÄ³ÌÐò
¹Ù·½ÏÂÔصØÖ·£ºhttp://utopia.knoware.nl/~hlub/uck/rlwrap/
°²×°¹ý³Ì£º
ÎÒÃÇÒ²¿ÉÒԲ鿴½âѹºóµÄtar°ü£¬²é¿´README°ïÖúÎļþ
shell>tar -zxvf rlwrap-0.36.tar.gz
sh ......

oracle sql loader


SQL*LOADERÊÇORACLEµÄÊý¾Ý¼ÓÔع¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþǨÒƵ½ORACLEÊý¾Ý¿âÖС£SQL*LOADERÊÇ´óÐÍÊý¾Ý
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨¡£
¡¡¡¡ÔÚNTÏ£¬SQL*LOADERµÄÃüÁîΪSQLLDR£¬ÔÚUNIXÏÂÒ»°ãΪsqlldr/sqlload¡£
¡¡¡¡ÈçÖ´ÐУºd:\oracle>sqlldr
SQL*Loader: Release 8.1.6.0.0 - Production on ÐÇÆÚ¶þ 1ÔÂ 8 11:06:42 2 ......

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


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