| 澶辨晥閾炬帴澶勭悊 |
|
甯哥敤OracleSQL鏁寸悊 PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1_rGpWhvjpesMFNSFFyBMTQ
鎻愬彇鐮侊細(xì)90ku
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
--cmd sys鐧誨綍/閫€鍑簅racle
sqlplus/nolog;conn/as sysdba;exit
--鏌ョ湅琛ㄧ┖闂翠嬌鐢ㄦ儏鍐?/div>
select * from dba_tablespace_usage_metrics;
--鍒犻櫎琛ㄧ┖闂達(dá)紝鐒跺悗鎵嬪姩鍒犻櫎鏁版嵁鏂囦歡鐗╃悊鏂囦歡
drop tablespace CRM_F_DATA_TABS including contents and datafiles;
--鏌ョ湅琛ㄧ┖闂翠笂鐨勭敤鎴?/div>
select distinct s.owner from dba_segments s where s.tablespace_name ='TBSNAME';
--鏌ョ湅琛ㄧ┖闂村叧鑱旀暟鎹枃浠?/div>
select t1.name,t2.name from v$tablespace t1,v$datafile t2 where t1.ts#=t2.ts# and t1.name = 'USERS';
--鍒涘緩琛ㄧ┖闂?/div>
create tablespace test1 datafile 'E:\app\user\oradata\orcl\test1.dbf' size 1000M;
--榪藉姞琛ㄧ┖闂?/div>
alter tablespace test1 add datafile 'E:\app\user\oradata\orcl\test2.dbf' size 1000M;
--鍒涘緩鐢ㄦ埛
create user hmfms_fx IDENTIFIED BY hmfms_fx default tablespace TBS_DATA temporary tablespace TBS_TEMP profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to hmfms_fx;
grant dba to hmfms_fx;
-- Grant/Revoke system privileges
grant create sequence to hmfms_fx;
grant unlimited tablespace to hmfms_fx;
--鏌ョ湅鐢ㄦ埛
select * from dba_users;
--鍒犻櫎鐢ㄦ埛
drop user HMFMS_PJ cascade;
--鏌ョ湅鐢ㄦ埛榪涚▼
select username,sid,serial# from v$session;
--鏉€榪涚▼
alter system kill session'67,508';
1銆佷笅闈㈢殑璇彞鐢ㄦ潵鏌ヨ鍝簺瀵硅薄琚攣錛?/div>
select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session s
where l.object_id銆€=銆€o.object_id and l.session_id=s.sid;
2銆佷笅闈㈢殑璇彞鐢ㄦ潵鏉€姝諱竴涓繘紼嬶細(xì)
alter system kill session '24,111'; (鍏朵腑24,111鍒嗗埆鏄笂闈㈡煡璇㈠嚭鐨剆id,serial#)
--鍒涘緩directory
create directory DIR_HMFMS as 'E:\app\yuminghan\admin\orcl\dpdump';
--鏌ョ湅directory
select * from dba_directories;
--鍒犻櫎directory
drop directory DIR_HMFMS1 ;
--鍏抽棴/寮€鍚暟鎹簱
shutdown immediate; startup;
--瀵煎嚭鏁版嵁搴?/div>
expdp hmfms_fx/hmfms_fx@ip:1521/orcl DIRECTORY=bxgjj DUMPFILE=hmfms_fx0425.dmp
--瀵煎叆鏁版嵁搴?/div>
impdp hmfms_fx/hmfms_fx@ORCL directory=DIR_HMFMS dumpfile=hmfms_fx0412.dmp
--瀵煎叆鏁版嵁搴撴椂鐢ㄦ埛鍚嶈〃絀洪棿涓嶅悓鏃訛紝鍋氭槧灝?/div>
impdp hmfms_fx/hmfms_fx@ORCL directory=DIR_HMFMS dumpfile=hmfms_fx0412.dmp logfile=crm_hx20180523.log REMAP_SCHEMA=hmfms_panjin:jhmfms_panjin remap_tablespace='EXAMPLE:CRM_F_DATA_TABS,EXAMPLE_TEMP:CRM_F_DATA_TABS_TEMP'
--鏌ヨ鐢ㄦ埛鎵€鐢ㄧ殑琛ㄧ┖闂達(dá)紝涓嶅寘鍚儲寮?/div>
select username,default_tablespace,temporary_tablespace from dba_users where username='CRMPRO';
select owner,table_name,tablespace_name from dba_tables where owner='CRMPRO';
select owner,tablespace_name,count(1) from dba_tables where owner='CRMPRO' group by tablespace_name,owner ;
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
