Category : Databases and related files
Archive   : UTIL91.ZIP
Filename : BRENTABS.SQL

rem BRENTABS.SQL - This SQL*Plus script builds a SQL*Plus script
rem that may be run to rename all tables in the
rem specified account with the prefix OLD.
rem You must have DBA privilege to run this
rem script and have the DBA synonyms created in
rem your account.
rem
rem Syntax:
rem $ SQLPLUS-S USERNAME/PASSWORD @BRENTABS OWNER_NAME
rem
rem Set up the SQL*Plus controls
rem
set echo off
set termout off
set feedback off
set verify off
set pause off
set linesize 80
set pagesize 0
rem
define ownername = "&1"
rem
spool rentabs.sql
rem
rem SQL statements
rem

select 'rename '||table_name||' to OLD_'||table_name||';'
from dba_tables
where owner like upper('&ownername')
order by table_name;

spool off
exit