ORACLEÊý¾Ýµ¼Èëµ½Ö¸¶¨µÄ±í¿Õ¼ä
create user Óû§Ãû identified by ÃÜÂë default tablespace ȱʡ±í¿Õ¼ä¡¡Temporary tablespace ÁÙʱ±í¿Õ¼ä;
grant connect,resource,dba to Óû§Ãû;
¡¡¡¡
revoke unlimited tablespace from Óû§Ãû;
¡¡¡¡
alter user Óû§Ãû quota 0 on Users;
alter user Óû§Ãû¡¡quota unlimited on Óû§È±Ê¡±í¿Õ¼ä;
--¹Ø¼üÊǺóÃæ3ÐÐÃüÁ±ØÐëÖ´ÐС£
--½Ó×ÅʹÓÃIMP¹¤¾ßµ¼ÈëÊý¾Ý¼´¿Éµ¼Èëµ½Óû§È±Ê¡±í¿Õ¼ä.
--EXAMPLE: USER NAME: GROUPCMS; tablespace:GROUPCMS
--DROP USER GROUPCMS CASCADE;
create user GROUPCMS identified by ABC123 default tablespace GROUPCMS¡¡ ;
grant connect,resource,dba to GROUPCMS;
revoke unlimited tablespace from GROUPCMS;
alter user GROUPCMS quota 0 on Users;
alter user GROUPCMS¡¡quota unlimited on GROUPCMS;
Ïà¹ØÎĵµ£º
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>shutdow ......
Oracle 9i¶¯Ì¬SGA¹ÜÀí
ÔÚOracle 9iÖУ¬¿ÉÒÔÉèÖÃSGA_MAX_SIZE£¬¸Ã²ÎÊýÓÃÒÔ¿ØÖƸ÷»º³å³ØÊ¹ÓõÄÄÚ´æ×ܺͣ¬±¾ÖÊÉÏÊÇÔÚ½ø³ÌÖÐÔ¤ÏÈ·ÖÅäÒ»¶ÎÐéÄâµØÖ·±¸Óöø²»·ÖÅäÎïÀíÄڴ棬ĿµÄÊÇ·ÀÖ¹ºÍ½ø³Ç˽ÓеØÖ·¶ÎµÄ³åÍ»¡£
Ö»Òª×ܵÄSGAÄÚ´æÉèÖò»³¬¹ýSGA_MAX_SIZEµÄÉèÖ㬸ü¸Ä¶¼¿ÉÒÔÁ¢¼´ÉúЧ¡£ÐèҪעÒâµÄÊÇ£¬ÔÚOracle 9iR1ÖУ¬¶¯Ì¬¼õСÄÚ´ ......
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>shutdow ......
Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as in ......