oracle imp/exp
Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
expµ¼³ö¹¤¾ß½«Êý¾Ý¿âÖÐÊý¾Ý±¸·ÝѹËõ³ÉÒ»¸ö¶þ½øÖÆÏµÍ³Îļþ.¿ÉÒÔÔÚ²»Í¬OS¼äÇ¨ÒÆ
ËüÓÐÈýÖÖģʽ£º
a. Óû§Ä£Ê½£º µ¼³öÓû§ËùÓжÔÏóÒÔ¼°¶ÔÏóÖеÄÊý¾Ý£»
b. ±íģʽ£º µ¼³öÓû§ËùÓбí»òÕßÖ¸¶¨µÄ±í£»
c. Õû¸öÊý¾Ý¿â£º µ¼³öÊý¾Ý¿âÖÐËùÓжÔÏó¡£
2. µ¼³ö¹¤¾ßexp½»»¥Ê½ÃüÁîÐз½Ê½µÄʹÓõÄÀý×Ó
$exp oa1/123@ oracle
Á¬½Óµ½: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ÊäÈëÊý×éÌáÈ¡»º³åÇø´óС: 4096 >
µ¼³öÎļþ: EXPDAT.DMP > D:/a.dmp
(2)U(Óû§), »ò (3)T(±í): (2)U > 3
µ¼³ö±íÊý¾Ý (yes/no): yes > yes
ѹËõÇø (yes/no): yes >
Òѵ¼³ö ZHS16GBK ×Ö·û¼¯ºÍ AL16UTF16 NCHAR ×Ö·û¼¯
¼´½«µ¼³öÖ¸¶¨µÄ±íͨ¹ý³£¹æÂ·¾¶...
Òªµ¼³öµÄ±í (T) »ò·ÖÇø (T: P): (°´ RETURN Í˳ö) > pfdept
. . ÕýÔÚµ¼³ö±í PFDEPTµ¼³öÁË 83 ÐÐ
Òªµ¼³öµÄ±í (T) »ò·ÖÇø (T: P): (°´ RETURN Í˳ö) >return
µ¼³ö³É¹¦ÖÕÖ¹, µ«³öÏÖ¾¯¸æ¡£
3. µ¼³ö¹¤¾ßexp·Ç½»»¥Ê½ÃüÁîÐз½Ê½µÄÀý×Ó
$exp oa1/123@oracle file=D:/all.dmp grants=y
˵Ã÷:°Ñoa1Óû§µÄËùÓÐ±íµ¼³öµ½ÎļþD:/all.dmp
$exp oa1/123@oracle tables=(pfdept,pfuser) file=D:/all.dmp grants=y
˵Ã÷:°Ñoa1 Óû§ÀïÁ½¸ö±íemp,deptµ¼³öµ½ÎļþD:/all.dmp
$exp oa1/123@oracle tables=pfdept query=\"where predeptid=0745\" file=D:/all.dmp
˵Ã÷:ÔÚexpÀïÃæ¼ÓÉϵ¼³öpfdept µÄ²éѯÌõ¼þpredeptid=0745
$exp parfile=username.par file=/directory1/username_1.dmp,/directory1/username_2.dmp filesize=2000M log=/directory2/username_exp.log
²ÎÊýÎļþusername.parÄÚÈÝ
userid=username/userpassword
buffer=8192000
compress=n
grants=y
˵Ã÷:username.parΪµ¼³ö¹¤¾ßexpÓõIJÎÊýÎļþ,ÀïÃæ¾
Ïà¹ØÎĵµ£º
¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂÛ35£ºÔÚAIX»·¾³ÏÂΪOracle¡¢sybase ʹÓÃÂãÉ豸 ÎÄÆ½ ÂãÉ豸ÊÂÒ»ÖÖÔÚUNIXϳ£ÓõÄÊý¾Ý¿âÊý¾Ý´æ´¢·½Ê½,ÔÚAIXÖÐÈç´Ë,ÔÚHP-UX\SCO UNIXµÈϵͳÖнÔÊÇÈç´Ë¡£Õâ¶ÎʱÆÚÒÔÀ´Ò»Ö±ÓÐͬ־ÃÇÓʼþѯÎÊÈçºÎʹÓÃÂãÉ豸¡£ÕâÀïÎÒ»ã×ÜһЩAIXÏÂÂãÉ豸µÄʹÓÃÎ ......
Oracle sqlplusÔ¶³ÌÁ¬½ÓÊý¾Ý¿â
sqlplus username/password@yunSID_192.168.1.5
¹«Ë¾Ê¹ÓÃlinux¿ª·¢»ú½øÐгÌÐò¿ª·¢Ê±£¬ÓÉÓÚ¿ª·¢ÓÃOracleÊý¾Ý¿âÊÇÓÉÈÕ·½Ìṩ£¬ËùÒÔ¾³£Ê¹ÓÃsqlplusÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿âÉϽøÐпª·¢,ÀýÈ磺
sqlplus username/password@servicename
ÓÚÊÇÏ룬ÓÃÎÒµÄÁ½Ì¨µçÄÔË«»ú»¥ÁªÊÔÒ»ÊÔ£¬Ò²Íæ¸ö&ldq ......
Ò»¡¢Æô¶¯
1.#su - oracle Çл»µ½oracleÓû§ÇÒÇл»µ½ËüµÄ»·¾³
2.$lsnrctl status ²é¿´¼àÌý¼°Êý¾Ý¿â״̬
3.$lsnrctl start &nb ......
SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual ......
·ÖÎöº¯Êý£¬×îÔçÊÇ´ÓORACLE8.1.6¿ªÊ¼³öÏֵģ¬ËüµÄÉè¼ÆÄ¿µÄÊÇΪÁ˽â¾öÖîÈç“ÀۼƼÆË㔣¬“ÕÒ³ö·Ö×éÄڰٷֱȔ£¬“ǰ-NÌõ²éѯ”£¬“ÒÆ¶¯Æ½¾ùÊý¼ÆËã”"µÈÎÊÌâ¡£Æäʵ´ó²¿·ÖµÄÎÊÌâ¶¼¿ÉÒÔÓÃPL/SQL½â¾ö£¬µ«ÊÇËüµÄÐÔÄܲ¢²»ÄÜ´ïµ½ÄãËùÆÚÍûµÄЧ¹û¡£·ÖÎöº¯ÊýÊÇSQLÑÔÓïµÄÒ»ÖÖÀ©³ä£¬Ëü²¢²»Êǽö½ ......