Oracle提取现有数据库表空间、角色、用户信息，并生成脚本

来源：互联网发布：云计算ppt模板下载编辑：程序博客网时间：2024/04/29 14:34

set head offset feedback offset echo offset termout offset linesize 300spool d:\zly_his\script\createtsp.sqlremark create tablespace ;Select ' Create TABLESPACE ' || tablespace_name  || '      DATAFILE ' || file_name ||'  SIZE ' || to_char(ROUND(bytes/1000000,0)) ||'M REUSE AUTOEXTEND     ON NEXT  32M MAXSIZE UNLIMITED ;' from dba_data_files where tablespace_name not in ('SYSTEM','USERS','TEMP');spool off;-----remark create user spool d:\zly_his\script\createuser.sqlselect ' create user '|| username || ' identified by values ''' || password || ''' default tablespace '|| DEFAULT_TABLESPACE || '  TEMPORARY TABLESPACE '||   TEMPORARY_TABLESPACE    ||';'from dba_users   where username not in ('SYS','SYSTEM','SCOTT','DBSNMP','CWKLP','OA','OA88');spool off----remark create role;set head offset feedback offset echo offset termout offset linesize 1000spool d:\zly_his\script\createrole.sqlselect 'create role ' || role || ' ;' from  dba_roles where role like 'ROLE%';spool offset head onset feedback onset echo onset termout onset linesize 80

0 0