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

linuxÏ´´½¨oracleÓû§±í¿Õ¼ä

 ¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩеıí
 ²Ù×÷²½ÖèÈçÏ£º
 1¡¢µÇ¼linux£¬ÒÔoracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓà su - oracleÃüÁîÇл»³ÉoracleÓû§£©
 2¡¢ÒÔsysdba·½Ê½À´´ò¿ªsqlplus£¬ÃüÁîÈçÏ£º sqlplus "/as sysdba"
 3¡¢²é¿´ÎÒÃdz£¹æ½«Óû§±í¿Õ¼ä·ÅÖÃλÖãºÖ´ÐÐÈçÏÂsql£º
select name from v$datafile;
 ÉϱߵÄsqlÒ»°ã¾Í½«ÄãµÄÓû§±í¿Õ¼äÎļþλÖòé³öÀ´ÁË¡£
 4¡¢´´½¨Óû§±í¿Õ¼ä£º
CREATE TABLESPACE NOTIFYDB DATAFILE '/oracle/oradata/test/notifydb.dbf' SIZE 200M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
5¡¢´´½¨Óû§£¬Ö¸¶¨ÃÜÂëºÍÉϱߴ´½¨µÄÓû§±í¿Õ¼ä
CREATE USER hc_notify IDENTIFIED BY hc_password DEFAULT TABLESPACE NOTIFYDB;
6¡¢¸³ÓèȨÏÞ
grant connect,resource to hc_notify;
grant unlimited tablespace to hc_notify;
grant create database link to hc_notify;
grant select any sequence,create materialized view to hc_notify;
¾­¹ýÒÔÉϲÙ×÷£¬ÎÒÃǾͿÉÒÔʹÓÃhc_notify/hc_passwordµÇ¼ָ¶¨µÄʵÀý£¬´´½¨ÎÒÃÇ×Ô¼ºµÄ±íÁË
 


Ïà¹ØÎĵµ£º

Oracle Silent Installations(¾²Ä¬°²×°)


 
Linux Æ½Ì¨ÏÂOracle Silent Installations(¾²Ä¬°²×°)£¬Ò»Ö±¶¼Ã»Óг¢ÊÔ¹ýÓÃÕâÖÖ·½·¨À´×°Êý¾Ý¿â¡£ ÒòΪÓи߼¶µÄ¹¤¾ß£¬¾ÍûÓбØÒªÔÚÀ´ÓÃÕâÖÖ·½·¨ÁË£¬Oracle µÄ½çÃæ»¹ÊDZȽϷ½±ã£¬¶øÇÒÎÒÃÇ»¹ÓÐXmanager ¹¤¾ß£¬ËùÒÔÔÚlinux ÏÂ×°Èí¼þ£¬»¹ÊǺܷ½±ãµÄ¡£
 
Òò´ËÒ²¾ÍûÓÐÌ«ÔÚÒâÕ ......

ʹÓÃmapviewµ¼shpÊý¾Ýµ½oracle spatial

MapViewer ÊÇÒ»¸ö J2EE ·þÎñ£¬ËüʹÓÃÓÉ Oracle Spatial ¹ÜÀíµÄ¿Õ¼äÊý¾ÝÀ´»æÖƵØÍ¼¡£MapViewer ÌṩµÄ·þÎñºÍ¹¤¾ßÒþ²ØÁ˿ռäÊý¾Ý²éѯºÍµØÍ¼²â»æµÄ¸´ÔÓÐÔ£¬Í¬Ê±Îª½Ï¸ß¼¶µÄÓû§Ìṩ¿ÉÒÔ×Ô¶¨ÒåµÄÑ¡Ïî¡£MapViewer Ö¼ÔÚÓë»ùÓÚλÖõķþÎñºÍÓ¦ÓóÌÐòÏ༯³É¡£
µ¥»÷´Ë´¦»ñµÃ Oracle Ó¦Ó÷þÎñÆ÷ MapViewer µÄÆÁÄ»ÕÕÆ¬¡£
http://www.or ......

oracle·ÖÒ³¾ÍÓÃÕâÒ»¾ä

·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ­×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *  
  from (SELECT AA.*, ROWNUM RN   ......

linux c alarm(0)µÄº¬Òå

Linux C¡¡¡¡alarmº¯Êý---Çë¿´×îºó
¡¡¡¡alarmÒ²³ÆÎªÄÖÖÓº¯Êý£¬Ëü¿ÉÒÔÔÙ½ø³ÌÖÐÉèÖÃÒ»¸ö¶¨Ê±Æ÷£¬µ±¶¨Ê±Æ÷Ö¸¶¨µÄʱ¼äµ½Ê±£¬ËüÏò½ø³Ç·¢ËÍSIGALARMÐźš£Òª×¢ÒâµÄÊÇ£¬Ò»¸ö½ø³ÌÖ»ÄÜÓÐÒ»¸öÄÖÖÓʱ¼ä£¬Èç¹ûÔÚµ÷ÓÃalarm֮ǰÒÑÉèÖùýÄÖÖÓʱ¼ä£¬ÔòÈκÎÒÔǰµÄÄÖÖÓʱ¼ä¶¼±»ÐÂÖµËù´úÌæ¡£
ËùÐèÍ·Îļþ
¡¡¡¡#include<unistd.h>
º¯Ê ......

LinuxÃüÁmodinfoÏÔʾkernelÄ£¿éÐÅÏ¢

modinfo(module infomation)
¹¦ÄÜ˵Ã÷£ºÏÔʾkernelÄ£¿éµÄÐÅÏ¢¡£
Óï¡¡¡¡·¨£ºmodinfo [-adhpV][Ä£¿éÎļþ]
²¹³ä˵Ã÷£ºmodinfo»áÏÔʾkernelÄ£¿éµÄ¶ÔÏóÎļþ£¬ÒÔÏÔʾ¸ÃÄ£¿éµÄÏà¹ØÐÅÏ¢¡£
²Î¡¡¡¡Êý£º
  -a»ò--author ¡¡ÏÔʾģ¿é¿ª·¢ÈËÔ±¡£ 
  -d»ò--description ¡¡ÏÔʾģ¿éµÄ˵Ã÷¡£& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ