delete數(shù)據(jù)恢復(fù)
1.打開(kāi)Flash存儲(chǔ)的權(quán)限
? ?ALTER TABLE tablename ENABLE row movement ;
2.把表還原到指定時(shí)間點(diǎn)
? ?flashback table tablename to timestamp to_timestamp('2008-02-28 10:40:00','yyyy-mm-dd hh24:mi:ss');
drop數(shù)據(jù)恢復(fù)（未重建同名的表時(shí)才有用）
flashback table tbl_corpinfo to before drop;
用戶(hù)密碼效期
SELECT username,PROFILE FROM dba_users;
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
自動(dòng)聚合表空間（類(lèi)似于清理碎片）
alter tablespace EXAMPLE coalesce;
oracle 11g 空表分配空間后才能導(dǎo)出到dmp
select table_name from user_tables where NUM_ROWS=0;
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;
dblink處理遠(yuǎn)端數(shù)據(jù)
1.本地?cái)?shù)據(jù)庫(kù)用戶(hù)demo登錄，查詢(xún)dblink權(quán)限
select * from user_sys_privs t where t.privilege like upper('%link%');
2.用sys登錄案站，給本地?cái)?shù)據(jù)庫(kù)用戶(hù)demo賦dblink權(quán)限
grant CREATE PUBLIC DATABASE LINK to demo;--demo為本地?cái)?shù)據(jù)庫(kù)用戶(hù)名
grant DROP PUBLIC DATABASE LINK to demo;--demo為本地?cái)?shù)據(jù)庫(kù)用戶(hù)名
3.然后以demo用戶(hù)登錄本地?cái)?shù)據(jù)庫(kù)
創(chuàng)建dblink（遠(yuǎn)端服務(wù)名：ORCL_253，link名：LINK_TO_253）
注意： 服務(wù)器上必須去配一個(gè)ORCL_253的監(jiān)聽(tīng)
create public database link
LINK_TO_253connect to "DEMO" identified by "DEMO" using 'ORCL_253';
或者
不配監(jiān)聽(tīng)棘街，用以下語(yǔ)句直接搞定
create public database linkLINK_TO_253connect to "DEMO" identified by "DEMO"using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.90.253)(PORT=1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';
4.查詢(xún)遠(yuǎn)端數(shù)據(jù)
select * from rda_corp_info@LINK_TO_253;
5.刪除dblink
DROP PUBLIC DATABASE LINK LINK_TO_253;
修改oracle數(shù)據(jù)庫(kù)的最大連接數(shù)
show parameter processes;show parameter sessions;
alter system set processes=500 scope=spfile;alter system set sessions=500 scope=spfile;
