¹ØÓÚ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