Windows Oracle 10GÊÖ¹¤´´½¨Êý¾Ý¿â
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤
ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃ湤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle OraDb10g_home1”—“ Configuration and Migration Tools”—“ Database ConfigurationAssistant”£©£¬Ò²¿ÉÒÔÔÚÃüÁîÐУ¨”¿ªÊ¼”—“ÔËÐД—“cmd”£©¹¤¾ßÖÐÖ±½ÓÊäÈëdbcaÀ´´ò¿ª¡£ÁíÒ»ÖÖ·½·¨¾ÍÊÇÊÖ¹¤½¨¿â£¬ÕâÒ²¾ÍÊÇÏÂÃæËùÒª½²µÄÄÚÈÝ¡£ ÊÖ¹¤½¨¿â±ÈÆðʹÓÃDBCA½¨¿âÀ´Ëµ£¬ÊDZȽÏÂé·³µÄ£¬µ«ÊÇÈç¹ûÎÒÃÇѧºÃÁËÊÖ¹¤½¨¿âµÄ»°£¬¾Í¿ÉÒÔʹÎÒÃǸüºÃµØÀí½âOracleÊý¾Ý¿âµÄÌåϵ½á¹¹¡£ÊÖ¹¤½¨¿âÐëÒª¾¹ý¼¸¸ö²½Ö裬ÿһ¸ö²½Ö趼·Ç³£¹Ø¼ü¡£Ëü°üÀ¨£º
£±¡¢ ´´½¨±ØÒªµÄÏà¹ØĿ¼
£²¡¢ ´´½¨³õʼ»¯²ÎÊýÎļþ
£³¡¢ ÉèÖû·¾³±äÁ¿Oracle_sid
£´¡¢ ´´½¨ÊµÀý
£µ¡¢ ´´½¨¿ÚÁîÎļþ
£¶¡¢ Æô¶¯Êý¾Ý¿âµ½nomount(ʵÀý)״̬
£·¡¢ Ö´Ðн¨¿â½Å±¾
£¸¡¢ Ö´ÐÐcatalog½Å²½±¾´´½¨Êý¾Ý×Öµä
£¹¡¢ Ö´ÐÐcatproc´´½¨package°ü
£±£°¡¢ Ö´ÐÐpupbld
£±£±¡¢ Óɳõʼ»¯²ÎÊýÎļþ´´½¨spfileÎļþ
£±£²¡¢ Ö´ÐÐscott½Å±¾´´½¨scottģʽ
×öÍêÁËÒÔÉϵIJ½ÖèÖ®ºó¾Í¿ÉÒÔʹÓÓSQL>alterdatabase open;”´ò¿ªÊý¾Ý¿âÕý³£µÄʹÓÃÁË¡£ÏÂÃ棬ÎÒ½«¾ßÌåµØ°ÑÒÔÉϵļ¸¸ö²½ÖèÓÃʵÑéÕ¹¿ªÀ´½²¡£ ʵÑéϵͳƽ̨£ºWindows Server 2000¡¡Êý¾Ý¿âϵͳ°æ±¾£ºOracle Database 10£Ç OracleµÄ°²×°Â·¾¶£ºDÅÌ¡¡.´´½¨µÄÊý¾Ý¿âÃû³Æ£ºbook £±¡¢´ò¿ªÃüÁîÐй¤¾ß£¬´´½¨±ØÒªÓÐÏà¹ØĿ¼
C:\>mkdir D:\oracle\product\10.1.0\admin\book
C:\>mkdir D:\oracle\product\10.1.0\admin\book\bdump
C:\>mkdir D:\oracle\product\10.1.0\admin\book\udump
C:\>mkdir D:\oracle\product\10.1.0\admin\book\cdump
C:\>mkdir D:\oracle\product\10.1.0\admin\book\pfile
C:\>mkdir D:\oracle\product\10.1.0\admin\book\create
C:\>mkdir D:\oracle\product\10.1.0\oradata\book
ÉÏÃæ´´½¨Ä¿Â¼µÄ¹ý³ÌÒ²¿ÉÒÔÔÚWindowsµÄͼÐνçÃæÖÐÈ¥´´½¨¡£ÆäÖÐ
D:\oracle\product\10.1.0\admin\bookĿ¼Ïµļ¸¸ö×ÓĿ¼Ö÷ÒªÓÃÓÚ´æ·ÅÊý¾Ý¿âÔËÐйý³ÌÖеĸú×ÙÐÅÏ¢¡£×îÖØÒªµÄÁ½ÉÏ×ÓĿ¼ÊÇbdumpºÍudumpĿ¼£¬bdumpĿ¼´æ·ÅµÄÊÇÊý¾Ý¿â¶¯Ðйý³ÌÖ
Ïà¹ØÎĵµ£º
Ö»ÊÇsqlserver ÌṩµÄÔ¶³ÌÊý¾Ý·ÃÎʺ¯Êý; ÔÚ±¾µØsqlserver ÖÐÈ¡ÍⲿÊý¾ÝÔ´Êý¾Ýʱºò¿ÉÓÃ;
¶ÔÁ¬½Ó±¾µØ oracle ²Ù×÷Ô¶³Ì oracle ²»ÄÜʹÓÃ; ²âÊÔ: pl/sql ÖÐʹÓÃ:
select * from openrowset(................); ÎÞЧ!!!!!!!!!!!!!!
ÔÚoracle ÖÐÐèÒª·ÃÎÊÔ¶³ÌÊý¾Ý,ÐèÒª½¨Á¢Ò»Á¬½ÓÔ¶³Ìoracle µÄ dblink ;
ÔÙÓÃÈçÏ·½ ......
oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö
OracleµÄimp/exp×é¼þÊÇÎÒÃdz£ÓõŤ¾ß£¬ËüµÄÒ»¸ö²Ù×÷ÔÔò¾ÍÊÇÏòϼæÈÝ¡£ÏÂÃæÊǾݴË×ܽáµÄ¼¸¸öʹÓùæÔòºÍÏà¹Ø²âÊÔ£º
¹æÔò1£ºµÍ°æ±¾µÄexp/imp¿ÉÒÔÁ¬½Óµ½¸ß°æ±¾£¨»òͬ°æ±¾£©µÄÊý¾Ý¿â·þÎñÆ÷£¬µ«¸ß°æ±¾µÄexp/imp²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄÊý¾Ý¿â·þÎñÆ÷
1.1 ʹÓÃ9i¿Í»§¶Ëͨ¹ýimpÁ¬ ......
ÔÚORACLEÖиø±í¡¢ÁÐÔö¼Ó×¢ÊÍÒÔ¼°¶ÁȡעÊÍ
1¡¢¸ø±íÌî¼Ó×¢ÊÍ£ºSQL>comment on table ±íÃû is '±í×¢ÊÍ";
2¡¢¸øÁмÓ×¢ÊÍ£ºSQL>comment on column ±í.ÁÐ is 'ÁÐ×¢ÊÍ';
3¡¢¶ÁÈ¡±í×¢ÊÍ£ºSQL>select * from user_tab_comments where comments is not null;
4¡¢¶ÁÈ¡ÁÐ×¢ÊÍ£ºSQL>select * from user_col_commnents wh ......