ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐЧÆÚÓÉĬÈϵÄ180ÌìÐ޸ijɓÎÞÏÞÖÆ”£º
sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ÐÞ¸ÄÖ®ºó²»ÐèÒªÖØÆô¶¯Êý¾Ý¿â£¬»áÁ¢¼´ÉúЧ¡£
http://four-corner.appspot.com/
Ïà¹ØÎĵµ£º
MapViewer ÊÇÒ»¸ö J2EE ·þÎñ£¬ËüʹÓÃÓÉ Oracle Spatial ¹ÜÀíµÄ¿Õ¼äÊý¾ÝÀ´»æÖƵØÍ¼¡£MapViewer ÌṩµÄ·þÎñºÍ¹¤¾ßÒþ²ØÁ˿ռäÊý¾Ý²éѯºÍµØÍ¼²â»æµÄ¸´ÔÓÐÔ£¬Í¬Ê±Îª½Ï¸ß¼¶µÄÓû§Ìṩ¿ÉÒÔ×Ô¶¨ÒåµÄÑ¡Ïî¡£MapViewer Ö¼ÔÚÓë»ùÓÚλÖõķþÎñºÍÓ¦ÓóÌÐòÏ༯³É¡£
µ¥»÷´Ë´¦»ñµÃ Oracle Ó¦Ó÷þÎñÆ÷ MapViewer µÄÆÁÄ»ÕÕÆ¬¡£
http://www.or ......
ÔÚlinuxϰ²×°oracleÊǼþ·±ËöµÄÊÂÇé¡£¾ßÌåÀ´½²·ÖΪһϼ¸´ó²½£º
1.ÐÞ¸Äϵͳ°æ±¾
vi /etc/redhat-release
×¢Ê͵ôµÚÒ»ÐУ¬Ìí¼ÓÒ»ÐУºredhat-4
2.°²×°Èí¼þ°ü
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh comp ......
Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾ Universal Installer жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí ......
[×ÊÁÏÀ´×ÔÓÚORACLEƵµÀ http://oracle.chinaitlab.com/induction/398193.html]
¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
¡¡¡ ......
1¡¢°²×°
2¡¢´´½¨“±¾µØNet·þÎñÃû”
3¡¢PLSQL Developer Á¬½Ó²âÊÔ
4¡¢´´½¨±í¿Õ¼ä
1.´ò¿ªsqlplus¹¤¾ß£º
sqlplus /nolog
2. Á¬½ÓÊý¾Ý¿â£º
conn /as sysdba
3. ´´½¨±í¿Õ¼ä£º
create tablespace camds datafile 'D:\oracle\product\10.2.0\oradata\camds\camds.dbf' size  ......