oracle¼¸¸ö¸ÅÄîÎÊÌâ
ÐÂÊÖ£¬¶ÔÓÚoracleÖеÄÊý¾Ý¿âʵÀý£¬·½°¸£¬Óû§Ö®¼äµÄ¹ØÏµÓе㲻̫Ã÷°×£¬Ï£Íû¸÷λ¸ßÊÖÖ¸½Ì¡£
Ôõô¸Ð¾õÔÚÊý¾Ý¿âʵÀýÖпÉÒÔÓжà¸öÓû§£¬¶øÃ¿¸öÓû§ÓÐÒ»¸ö·½°¸£¬ÔÚ·½°¸Ï²ŶÔÓ¦ºÜ¶àÊý¾Ý¿â¶ÔÏó£¨Èç±í£¬ÊÓͼµÈ£©
ʵÀýÊÇÒ»×éORACLEºǫ́½ø³Ì¼°Ò»¿éÄڴ棨ͨ³£³ÆÖ®ÎªSGA£¬ÏµÍ³È«¾ÖÇø£©µÄ¼¯ºÏ¡£
·½°¸(schema)£¬ÊÇָijһÓû§¼°ÆäËùÓжÔÏó£¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°üµÈµÈ£©µÄ¼¯ºÏ¡£
Èç¹ûijÓû§ÎÞÈκζÔÏó£¬ÄÇô£¬Êý¾Ý¿âÀïÖ»´æÔÚ¸ÃÓû§£¬²¢ÎÞ¸Ãschema¡£
1£¬Êý¾Ý¿âʵÀý¾ÍÊǺǫ́½ø³Ì ÔÚ¼ÓÉÏ Ò»¿éÄÚ´æÇø(SGAÓëPGA£¬ÓеÄʱºò»¹ÓÐUGA)¡£
2£¬·½°¸¾ÍÊǽ¨Á¢µÄÓû§ÒÔ¼°¸ÃÓû§ÏÂÃæËùÊôµÄËùÓжÔÏ󣨰üÀ¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°ü¡¢Ë÷Òý¡¢´¥·¢Æ÷µÈµÈ£©µÄ¼¯ºÏ¡£
3£¬Óû§¾ÍÊǼòµ¥µÄ´¿´âµÄÓû§£¬Èç¹ûÊǽ¨Á¢µÄ¿ÕÓû§£¬¾ÍÊÇ˵Óû§ÏÂÃæÃ»ÓÐÈÎºÎ±í¡¢ÊÓͼ¡¢¹ý³ÌµÈ¶ÔÏóµÄ»°£¬ÄÇô£¬Êý¾Ý¿âÀïÃæ¿ÉÒÔÕâô˵£¬Ö»´æÔÚÓû§£¬¶øÃ»ÓÐÏàÓ¦µÄ·½°¸schema¡£
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......