set term off set heading on set verify off set feedback off
set linesize 2000 set pagesize 30000 set long 999999999 set longchunksize 999999
column id format a30 column super_id format a30 column levels format 9999999999
column table_name format a30 column owner format a30
set term on prompt "input schema:" --从控制台接受变量值 define S_SCHEMA=&SCHEMA set term off
column dbid new_value spool_dbid --列dbid值给变量spool_dbid column inst_num new_value spool_inst_num select dbid from v$database where rownum = 1; --给dbid赋值 select instance_number as inst_num from v$instance where rownum = 1; column spoolfile_name new_value spoolfile select 'spool_'||(select name from v$database where rownum=1) ||'_'|| (select instance_name from v$instance where rownum=1) ||'_'||to_char(sysdate,'yy-mm-dd_hh24.mi')||'_static' as spoolfile_name from dual; spool &&spoolfile..html
prompt
版本
select t.id,t.super_id,t.levels from T1 t;
prompt
整个用户有多大 单位GB select sum(bytes)/1024 /1024 /1024 "GB" from dba_segments where owner = '&S_SCHEMA';