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

¹ØÓÚORACLE¸¨ÖúÓï¾ä

--JOBS
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT(job => X,
what => 'sp_test();',
next_date => to_date('28-04-2009 11:58:00',
'dd/mm/yyyy hh24:mi:ss'),
interval => 'SYSDATE+1');
END;
/
commit;
select to_char(sysdate-90,'yyyymmdd') from dual;  --Ñ¡ÔñÈÕÆÚ
select * from dba_jobs;--²é¿´×÷Òµ
CREATE USER SLCARD  PROFILE DEFAULT
    IDENTIFIED BY slcard DEFAULT TABLESPACE USERS
    ACCOUNT UNLOCK;
GRANT CONNECT TO SLCARD;
GRANT DBA TO SLCARD;
GRANT RESOURCE TO SLCARD;
--REVOKE DBA,CONNECT,RESOURCE from SLCARD;
1.²é¿´ËùÓÐÓû§£º
  select * from dba_users;
  select * from all_users;
  select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
  select * from dba_sys_privs;
  select * from user_sys_privs;
3.²é¿´Óû§¶ÔÏóȨÏÞ£º
  select * from dba_tab_privs;
  select * from all_tab_privs;
  select * from user_tab_privs;
4.²é¿´ËùÓнÇÉ«£º
  select * from dba_roles;
5.²é¿´Óû§»ò½ÇÉ«ËùÓµÓеĽÇÉ«£º
  select * from dba_role_privs;
  select * from user_role_privs;
6.²é¿´Á¬½ÓÊý
select username,count(username) from v$session where username is not null group by username
-- È·¶¨½ÇÉ«µÄȨÏÞ
select * from role_tab_privs ;  Êý¾Ý×ÖµäÊÓͼ°üº¬ÁËÊÚÓè½ÇÉ«µÄ¶ÔÏóȨÏÞ
select * from role_role_privs ;             °üº¬ÁËÊÚÓèÁíÒ»½ÇÉ«µÄ½ÇÉ«
select * from role_sys_privs ;              °üº¬ÁËÊÚÓè½ÇÉ«µÄϵͳȨÏÞ
-- È·¶¨Óû§ÕÊ»§ËùÊÚÓèµÄȨÏÞ
select * from DBA_tab_privs ;   Ö±½ÓÊÚÓèÓû§ÕÊ»§µÄ¶ÔÏóȨÏÞ
select * from DBA_role_privs ;  ÊÚÓèÓû§ÕÊ»§µÄ½ÇÉ«
select * from DBA_sys_privs ;   ÊÚÓèÓû§ÕÊ»§µÄϵͳȨÏÞ
²é¿´µ±Ç°Óû§È¨ÏÞ:
select * from session_privs;¡¢
--¸ü¸ÄÁÙʱ±í¿Õ¼ä
ALTER database TEMPFILE 'I:\oracle\oradata\sldev\temp02.dbf' reSIZE 300M;
ALTER TABLESPACE TEMP ADD TEMPFILE 'I:\oracle\oradata\sldev\temp02.db


Ïà¹ØÎĵµ£º

oracleÖµµÃ̽ÌÖµÄÎÊÌâ

¾­³£×öһЩÊý¾Ý¿â²Ù×÷£¬ÔÚ½¨Á¢±íµÄʱºò£¬Ñ¡Ôñ×Ö¶ÎÀàÐÍʱ£¬ÓйØ×Ö·û´®ÀàÐ͵ÄÑ¡Ôñ×ÜÊÇÓÐЩģºý¡£
¡£char
¡£varchar2
¡£nvarchar2
¡£nchar
¹ØÓÚÉÏÃæÁ½¸öÎÒÓеãÓ¡Ïó¡£CHARµÄ³¤¶ÈÊǹ̶¨µÄ£¬¶øVARCHAR2µÄ³¤¶ÈÊÇ¿ÉÒԱ仯µÄ£¬±ÈÈ磬´æ´¢×Ö·û´®“abc"£¬¶ÔÓÚCHAR (20)£¬±íʾÄã´æ´¢µÄ×Ö·û½«Õ¼20¸ö×Ö½Ú(°üÀ¨17¸ö¿Õ×Ö·û)£ ......

ORACLEÆô¶¯

 
ORACLEÖ÷ÒªÓÉÁ½²¿·Ö×é³É£ºInstanceºÍDatabase¡£InstanceÊÇÖ¸Ò»×éºǫ́½ø³Ì/Ï̺߳ÍÒ»¿é¹²ÏíÄÚ´æÇøÓò£¬¶øDatabaseÊÇÖ¸´æ´¢ÔÚ´ÅÅÌÉϵÄÒ»×éÎïÀíÎļþ¡£
ORACLEÊý¾Ý¿âµÄÆô¶¯Ö÷Òª·Ö3¸ö²½Ö裺
1¡¢Æô¶¯µ½nomount״̬£»
2¡¢Æô¶¯µ½mount״̬£»
3¡¢Æô¶¯µ½open״̬¡£
ÏÂÃæ·ÖÎöÒ»ÏÂÆô¶¯µÄ¸÷¸ö²½Ö裺
Ò»¡¢Æô¶¯µ½nomount״̬
......

ÕùÏÈÌåζOracle 11gµÄÐÂÌØµã

 ¸ú×ÅÕ⼸ÌìOracle OpenWorld´ó»áµÄ¾ÙÐУ¬Oracle11gµÄÐÂÌØÕ÷Ô½À´Ô½¶àµÄ±»Õ¹ÏÖ³öÀ´¡£
¡¡¡¡ÒÔǰ£¬ÎÒÔø¾­Òý¼û¹ýOracle11g½«¿ÉÄÜÔÚ10Ô·ݵÄÕâ¸ö´ó»áÉÏÍÆ³ö£¬µ±³õÖÁÓÚAlpha°æµÄÐÅÏ¢ÒѾ­¿ÉÒÔ¼ûµ½£¬ÏÖʱ³öÏÖµÄÒѾ­ÊÇBeta°æ£¬ÀëOracle11gµÄÕýʽ°æÒѾ­²»Ô¶¡£
¡¡¡¡Laurent Schneider ÔÚËûµÄBlogÖÐ̸µ½£¬¶ÔÓÚOracle11gµÄÃû×Ö»¹ ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Èý)

 1.¶à°æ±¾£º¶ÁÒ»Ö²éѯ  ·Ç×èÈû²éѯ
Oracle ²ÉÓÃÁËÒ»ÖÖ
¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7 Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£
²»¹ý£¬ÊµÖÊÉϽ²£¬Oracle ÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽá¹û¡£
·Ç×èÈû²éѯ£º²éѯ²»» ......

oracle´óÊý¾ÝÁ¿µ¼È루sqllaoder)

 ½ñÌì×öÁË1¸öÊý¾Ýµ¼ÈëÐèÇó£¬Îı¾¼Ç¼ÓÐ12Íò¶àÌõ£¬TXTÎļþ´óС6M¶à£¬ÒòΪÒÔǰ¶¼ÊÇÓÃoracleµÄtext import·½Ê½µ¼È룬¸ÕÊÔÑéÁËһϣ¬²»ÁéÑ飬µ±µ¼Èëµ½2Íò¶àÌõµÄʱºò£¬PLSQL¾Íµ±µôÁË£¬×ß²»¶¯ÁË¡£
 ÒòΪ¿¼Âǵ½1´Îµ¼È룬ËùÓоö¶¨²ÉÓÃSQLLOADERµÄ·½Ê½¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ