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

OracleÊý¾Ýµ¼³öµ½DBFµÄÎÊÌâ

 OracleÊý¾Ýµ¼³öºÜ¼òµ¥£¬µ«ÎªÁËÌá¸ßËÙ¶È£¬ÎÒÒ»°ã²»Ö±½Óµ¼³ö³ÉDBF£¬¶øÊÇÏȵ¼³ö³ÉCSV¸ñʽµÄÎı¾Îļþ¡£
½ñÌì¾ÍÓöµ½Ò»¸öÎÊÌ⣬µ¼³öµÄcsvÔÚת»»³Édbfʱ³öÏÖÁ˺ܶà¿ÕÐС£¾­¹ý²éÕÒÎÊÌ⣬·¢ÏÖÊÇ×Ö¶ÎÖк¬Óл»Ðзûµ¼Ö¡£
ʹÓÃ
select Replace(zsyj,chr(13)||chr(10),'')  as SXPD  from TableName
½â¾öÎÊÌâ¡£


Ïà¹ØÎĵµ£º

ÈçºÎ¿ª·¢ORACLE´æ´¢¹ý³Ì

 Ò». ¸ÅÊö
¡¡¡¡Oracle´æ´¢¹ý³Ì¿ª·¢µÄÒªµãÊÇ£º
¡¡¡¡• ʹÓÃNotepadÎı¾±à¼­Æ÷£¬ÓÃOracle PL/SQL±à³ÌÓïÑÔдһ¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖд´½¨Ò»¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐʹÓÃSQL*Plus¹¤¾ßÔËÐд洢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐÐ޸Ĵ洢¹ý³Ì;
¡¡¡¡• ͨ¹ý±àÒë´íÎóµ÷ÊÔ´æ´ ......

Oracle»ù±¾²Ù×÷

1.´´½¨±í¿Õ¼ä
  create tablespace test datafile'c:\test.dbf' size 10m;  //Ãû×Ö²»ÒªÎªÊý×Ö
2.´´½¨Óû§
create user userName identified by password;  //²»ÒªÎªÊý×Ö
3.¸øÓû§ÊÚȨ
grant dba to userName; --ÊÚÓèDBAȨÏÞ
grant unlimited tablespace to userName;--ÊÚÓè²»ÏÞÖÆµÄ±í¿Õ¼ä
grant sele ......

OracleÖØ×öÈÕÖ¾Îļþ³£ÓòÙ×÷

Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖÆ²úÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, ......

oracle 10gÈçºÎ¹Ø±ÕºÍ´ò¿ª×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢

http://www.51testing.com/?uid-16403-action-viewspace-itemid-101605
 Ò»¡¢ORACLE10g×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢--×Ô¶¯analyze
´ÓOracle Database 10g¿ªÊ¼£¬OracleÔÚ½¨¿âºó¾ÍĬÈÏ´´½¨ÁËÒ»¸öÃûΪGATHER_STATS_JOBµÄ¶¨Ê±ÈÎÎñ£¬ÓÃÓÚ×Ô¶¯ÊÕ¼¯CBOµÄͳ¼ÆÐÅÏ¢¡£
Õâ¸ö×Ô¶¯ÈÎÎñĬÈÏÇé¿öÏÂÔÚ¹¤×÷ÈÕÍíÉÏ10£º00-6£º00ºÍÖÜĩȫÌì¿ªÆ ......

CentOS5.2Éϰ²×°Oracle 10g 10.0.2.1.0

×¢Ò⣺ΪSWAP·ÖÅäµÄ¿Õ¼äÒª³¬¹ý1G£¬Òª²»È»ºóÃæ×°Oralce»áÒòΪ¿Õ¼ä²»×ã¶øÎÞ·¨°²×°¡£²¢ÇÒÒª¹Ø±Õ·À»ðǽ£¬¹Ø±ÕSELIINUX
ÐÞ¸ÄhostÎļþ
Hosts File
# vi /etc/hosts
192.168.10.10 oracle oracle.localdomain oracle
127.0.0.1 oracle localhost.localdomain localhost
×¢Ò⣺ÄãÒª°Ñ192.168.10.10¸Ä³ÉÄã×Ô¼ºµÄIP£¬ÎÒÕâÀïÖ»ÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ