暂无图片
暂无图片
5
暂无图片
暂无图片
暂无图片
expdp逻辑迁移一键收集脚本
3755
5页
118次
2021-09-14
5墨值下载
column OWNER for a30
column DIRECTORY_NAME for a30
column DIRECTORY_PATH for a50
column PARAMETER for a40
column VALUE for a40
column sid format 9999
column command format a20
column program format a25
column username format a15
column machine format a15
column event format a25
column sql_text format a40
column name format a30
column member format a30
column type format a20
column value format a35
column RY_TABLESPACE for a20
column PROFILE for a40
column table_name for a50
column grantor for a30
column GRANTEE for a30
column KSPPDESC for a50
column KSPPINM for a50
column KSPPSTVL for a50
column FILE_NAME for a70
column DB_LINK for a40
column HOST for a40
column table_name for a50
column segment_name for a50
set linesize 1000
set trims on
set echo off
set termout off
spool user_exp_check.log
create table exp_check as
select 1 as id , username from dba_users
where account_status='OPEN'
and username not in ('ANONYMOUS', 'CTXSYS', 'DBSNMP', 'EXFSYS',
'LBACSYS','MDSYS', 'MGMT_VIEW', 'OLAPSYS', 'ORDDATA', 'OWBSYS','ORDPLUGINS',
'ORDSYS', 'OUTLN', 'SI_INFORMTN_SCHEMA', 'SYS','SYSMAN', 'SYSTEM',
'WK_TEST', 'WKSYS', 'WKPROXY','WMSYS', 'XDB')
;
set heading off
set feedback off
select '##check directorts' from dual;
set heading on
set feedback on
select * from dba_directories;
set heading off
set feedback off
select '##check Character set' from dual;
set heading on
set feedback on
SELECT * FROM NLS_DATABASE_PARAMETERS;
set heading off
set feedback off
select '##check open user' from dual;
set heading on
set feedback on
select username,default_tablespace,temporary_tablespace,profile,account_status
from dba_users where account_status='OPEN' order by 1,2;
set heading off
set feedback off
select '##check user privilege and role' from dual;
set heading on
set feedback on
select owner,table_name,grantor,privilege from dba_tab_privs where grantee in
(select username from exp_check);
select grantee,privilege from dba_sys_privs where grantee in (select username
from exp_check) union select grantee,privilege from dba_sys_privs where grantee
in (select granted_role from dba_role_privs where grantee in (select username
from exp_check));
set heading off
set feedback off
select '##check user index' from dual;
set heading on
set feedback on
select owner,count(*) from dba_indexes where owner in (select username from
exp_check) group by owner order by 1,2;
set heading off
set feedback off
select '##check user lob' from dual;
set heading on
set feedback on
select l.owner,l.table_name,l.segment_name,sum(s.Bytes)/1024/1024/1024 GB from
dba_lobs l left join dba_segments s on l.segment_name=s.segment_name where
l.owner in (select username from exp_check) group by
l.owner,l.table_name,l.segment_name order by 4;
set heading off
set feedback off
select '##check user object count' from dual;
set heading on
set feedback on
select owner,object_type,status,count(*) from dba_objects where owner in
(select username from exp_check) and object_type !='LOB' group by
owner,object_type,status order by 1,2;
set heading off
set feedback off
select '##check user object in system/sysaux' from dual;
set heading on
set feedback on
select owner,segment_name,tablespace_name from dba_segments where owner in
(select username from exp_check) and tablespace_name in ('system','sysaux');
/*
if user segment data in sys tablespace
table:alter table tab_name move tablespace tbs_name;
index:alter index index_name rebuild tablespace tbs_name;
*/
set heading off
set feedback off
select '##check invalid object' from dual;
set heading on
set feedback on
select owner,object_type,count(*) from dba_objects
where owner in (select username from exp_check)
and status='INVALID'
and object_type not in ('INDEX','LOB') group by owner,object_type order by
of 5
5墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜