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£©Óû§·½Ê½£¬½«Ö¸¶¨Óû§µÄËùÓжÔÏó¼°Êý¾Ýµ¼³ö/µ¼
Ïà¹ØÎĵµ£º
http://www.javaeye.com/topic/366991#
×÷Ϊһ¸ö¿ª·¢ÈËÔ±£¬¿ªÊ¼ÈÏÕæÏµÍ³Ñ§Ï°
Oracle SQLÒ²Ö»ÓÐÔÂÓ֮࣬ǰµÄ
SQLÖª
ʶ½ö½öÊÇÏîÄ¿ÀïÃæÓõ½Ê²Ã´¾ÍÈ¥¿´Ê²Ã´£¬¼òµ¥Ëµ¾ÍÊÇ
Read The Fxxking Guide¡£ÔÚϵͳѧϰ
Oracle
SQL֮ǰ£¬°³µÄÏë·¨¾ÍÊÇ“°´ÕÕÐèÇóÍê³É¹¦ÄÜ£¬Ê£ÏµĽ»¸ø
DBAÀ´´¦À픡£Õâ¸öÏë·¨´ÓÕûÌåÀ´¿´ÏÔ ......
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ´¦Àí
MYSQLÓÐ ......
¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄÒ»Ð©ÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Î ......
SQL Server¿ª·¢ÕßOracle¿ìËÙÈëÃÅ http://kb.cnblogs.com/a/853694 ¼òµ¥¸ÅÄîµÄ½éÉÜ 1. Á¬½ÓÊý¾Ý¿â
S: use mydatabase
O: connect username/password@DBAlias
conn username/password@DBAlias 2. ÔÚOracleÖÐʹÓÃDual, DualÊÇO ......