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

oracle Êý¾Ý¿â±¸·Ý

È«Êý¾Ý¿â±¸·Ý½¨ÒéÓÃoracle×Ô´øµÄ expÃüÁî¡£
µ¼Ä³ÕűíµÄ»°£¬»òÕß±¸·Ýij¸öÓû§µÄÐÅÏ¢£¬¿ÉÒÔµ½
Tool-¡·export table µ¼±í
Tool-¡·export user object µ¼Óû§µÄÊý¾Ý¡£
-----------------------------------------------------------------------------------------
ÔÚoracleÖÐ,Ö´ÐÐsqlÎļþ,¿ÉÒÔдһ¸öÅú´¦ÀíÎļþ
sqlplus  scott/tiger@orcl @c:\example.sql
Ö´ÐÐÅú´¦ÀíÎļþ¾ÍÐÐÁË


Ïà¹ØÎĵµ£º

OracleÊÇÈçºÎ¹¤×÷µÄ ³ÂţѧIT

ÏàÐÅ´ó¼Ò¿´ÁËÕâÆªÎÄÕ¶ÔOracleÈçºÎ¹¤×÷ÓÐÒ»¸öÐÎÏóµÄÁ˽⣡
Õª×Ô----¡¶Oracle±¸·ÝÓë»Ö¸´¡·
-----------------------------------------------------------------------------------------------------------------
Ò»¸öÃû½ÐSidµÄÄÐÈË£¬¿ñÈȵذ®ºÃÅÄÉã¡¢±£´æºÍÕûÀíÕÕÆ¬¡£SidµÄÆÞ×ÓÃû½ÐDebbie£¬ËûÃÇÓÐÈý¸ö¶ù×ÓLogan¡¢Archie ......

ÓÃOracle²éѯÓï¾äÓ¦Óþ­Ñé×ܽá


ÓÃOracle²éѯÓï¾äÓ¦Óþ­Ñé×ܽá
¡¡ÒÔϵÄÎÄÕÂÖ÷ÒªÊǽéÉÜOracle²éѯÓï¾äµÄʵ¼ÊÓ¦Óõľ­Ñé×ܽᣬÄãÈç¹û¶ÔOracle²éѯÓï¾äµÄʵ¼ÊÓ¦ÓøÐÐËȤµÄ»°Äã¾Í¿ÉÒÔµã»÷ÒÔϵÄÎÄÕ½øÐйۿ´ÁË¡£ Ï£Íû»á¸øÄã´øÀ´Ò»Ð©°ïÖúÔÚ´Ë·½Ãæ¡£
¡¡¡¡1. select * from table_name where rownum>begin and rownum< end
¡¡¡¡2.sql = "select * fr ......

Íæ×ªOracle£¨2£©

sql*plus ÃüÁî
//Ö´Ðнű¾
@ºÍstart d:/a.txt;
//Ð޸Ľű¾
edit d:/a.txt;
//½«ÄÚÈÝÊäÈëµ½Îı¾ÖÐ
sloop d:/a.txt;  //¿ªÊ¼¼Ç¼ÆÁÄ»ÄÚÈÝ
sloop off;  //¼Ç¼½áÊø
//Á´½ÓµÇ¼Êý¾Ý¿â
connect system/919959 as sysdba/sysoper;  //ȨÏÞ×î´ódba
connect sys/919959;
connect scott/ti ......

Íæ×ªOracle£¨1£©

Oracle°²×°Æª
°æ±¾£ºwin32_11gR1_database_1013
ϵͳ£ºwin7
Äڴ棺3g£¨Å¼×Ô¼ºµØ-0-£©
1¡¢ÒòΪ²Ù×÷ϵͳѡÔñÁËwin7£¬ËùÒÔÔÚ°²×°Ö®Ñ¡ÐèÒªÐÞ¸ÄÒ»ÏÂÅäÖÃÎļþ£¬database\stage\prereq\db\refhost.xml
2¡¢ÐÞ¸ÄÍêÅäÖÃÎļþºó£¬µãinstall°²×°¼´¿É£¬µÈdos½çÃæ¼ÓÔØÍêºóÌø³öÈçϽçÃæ
 
 3¡¢ÏÂÒ»²½
4¡¢Ñ¡ÔñÆóÒµ°æ£¬È»ºó ......

¿ªÊ¼Ê¹ÓÃoracle ³ÂţѧIT

1£¬oracle tools£ºOUI¡¢DBCA¡¢OEM¡¢SQL*PLUS¡¢NETCA¡¢µÚÈý·½¹¤¾ß£¨toad¡¢PL\SQL developer£©
2£¬¿ÉʹÓÃresponsefile¿ìËÙȥͼÐΰ²×°oracle£¬ÔÚÔ´°²×°Îļþ/responseÀïÃæÓÐһЩģ°åÅäÖÃrpsÎļþ
3£¬Ô¤ÖÃÓû§ÊÇsysÓû§ÓësystemÓû§£ºsysÊÇoracleÊý¾Ý¿â
ÖÐȨÏÞ×î¸ßµÄÕʺţ¬¾ßÓÐcreate
databaseµÄȨÏÞ£¬¶øsystemûÓÐÕâ¸öȨÏÞ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ