Re: table creation

RE: Export User tables...

In the EXPORT Utility you can select a table one at a time...

I had a need to export all tables in a certain naming convention. PM_xxxxxxx

I wrote this script to extract the tables and create a batch file to do the export from the command line.

After the file was spooled... I had to

chmod +x userexp

in order to make it executable on my SUN.

steve schultz
sschultz_at_snoopy.46tg.af.mil

• begin sql script ----- exp_usr.sql - export subset of user tables set heade off set verify off set feedback off

spool userexp
select 'exp userid=userid/pw tables=('

||tablename||' ) file='
||tablename||'.exp log='
||tablename||'_exp.log'

from user_tables
where table_name like upper('&user_table') /

spool off

• end of sql script ------