all_users_tables_scripts.sh

------bazı kullanıcıların tüm tablolarının scriptleri----

#!/usr/bin/ksh
. $HOME/.profile

sqlplus -s /nolog << EOF > /dev/null
connect ORHAN/PASSWORD@ORCL

set verify off;
set termout off;
set feedback off;
set pagesize 0;
set heading off
set long 40000

SPOOL /tmp/orhan/all_users_tables_scripts.txt

select dbms_metadata.get_ddl('TABLE',u.table_name,u.owner) from dba_tables u
where u.owner in('OERIPEK','AATES','MCAN');

set heading off
set recsep off
col text format a80 word_wrap
spool off;
----------------------------------------------