Íêȫɾ³ýOracle 10g
Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£>ÉèÖã>¿ØÖÆÃæ°å£>¹ÜÀí¹¤¾ß£>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£>³ÌÐò£>Oracle – OraDb10g_home1>Oracle Installation Products£> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal Installer±¾Éí²»Äܱ»É¾³ý;
3¡¢ÔËÐÐregedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE,°´del¼üɾ³ýÕâ¸öÈë¿Ú;
4¡¢ÔËÐÐregedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services,¹ö¶¯Õâ¸öÁбí,ɾ³ýËùÓÐOracleÈë¿Ú;
5¡¢ÔËÐÐrefedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application,ɾ³ýËùÓÐOracleÈë¿Ú;
6¡¢ÓÒ¼üÎҵĵçÄÔ£>ÊôÐÔ£>¸ß¼¶£>»·¾³±äÁ¿,ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨;
7¡¢´Ó×ÀÃæÉÏ¡¢STARTUP(Æô¶¯)×é¡¢³ÌÐò²Ëµ¥ÖÐ,ɾ³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê;
8¡¢É¾³ýc:\Program Files\OracleĿ¼;
9¡¢ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼;
10¡¢É¾³ýÓëOracleÓйصÄÎļþ,Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle,ɾ³ýÕâ¸öÈë¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼,²¢´ÓWindows XPĿ¼(Ò»°ãΪd:\WINDOWS)ÏÂɾ³ýÒÔÏÂÎļþORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ;
11¡¢WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î,ɾ³ý¸Ã¶Î;
12¡¢ÈçÓбØÒª,ɾ³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN;
13¡¢µ½Ê¼þ²é¿´Æ÷ÖÐ,ɾ³ýOracleÏà¹ØµÄÈÕÖ¾ ˵Ã÷:Èç¹ûÓиö±ðDLLÎļþÎÞ·¨É¾³ýµÄÇé¿ö,Ôò²»ÓÃÀí»á,ÖØÐÂÆô¶¯,¿ªÊ¼Ðµİ²×°,°²×°Ê±,Ñ¡ÔñÒ»¸öеÄĿ¼,Ôò,°²×°Íê±Ï²¢ÖØÐÂÆô¶¯ºó,ÔÀ´µÄĿ¼¼°Îļþ¾Í¿ÉÒÔɾ³ýµôÁË¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÔÚdb2ºÍoracleÖеĶÔÊ÷µÄµÝ¹é²éѯÓï¾ä¡£
±í½á¹¹£º
create table MAIN_NODE (
MLA_ID INTEGER not null , //½ÚµãID
MLA_ROOTID &nb ......
ÔÚʵ¼Ê¹¤×÷ÖУ¬¾³£Òª´ÓÊý¾Ý¿âÖе¼³öÊý¾Ý»òÍùÊý¾Ý¿âÖе¼ÈëÊý¾Ý¡£µ±Óöµ½Êý¾ÝÁ¿½Ï´óʱ£¬¾ÍÐèÒªµ¼ÈëÎı¾¸ñʽµÄÊý¾Ý£¬Ò»°ãµ¼ÈëµÄÊý¾Ý¸ñʽÓÐtxt£¬csvµÈ¡£ÒÔÏÂÖ÷Òª½éÉÜÎÒÔÚʵ¼Ê¹¤×÷ÖÐÏòoracleÖе¼ÈëÊý¾ÝµÄÁ½¸öʵÀý¡£
1.ʹÓÃPL/SQL DeveloperµÄText Importer
£¨1£©´Ó²Ëµ¥ÖÐѡȡText Importer¹¦ÄÜ¡£
Tool&mda ......
·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......