writing database tables into a file in unix

UNIX for Advanced & Expert Users
1

I want to collect the database tables(Ex: Emp,Sal,Bonus...etc)
in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ?

Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log
i want to change this into
Ex:- Import jason/jason1 tables=i_tables.txt log=j1.log

where i_tables.txt should contain emp,sal,bonus.
How i can acheive this at the commnad prompt in unix .

Thanks !

2

Please don't post the same question in more than one forum.

I have removed the duplicate post.

Cheers
ZB

3

you shoul be able to do this with a "par" file.
Here is small tip regarding export. It is possible to make a selective table export with parameter tables.

$exp parfile=exp.par

Example of parameter file:

$ cat exp.par
buffer=8388608
file=artist_full.dmp
log=artist_exp.log
consistent=y
tables=(emp,sal,bonus,...)
userid=system/manager

4

The original question is rather unclear. It seems as though he only wants to extract the DDL.

You can do this as follows:

exp userid=user/pwd rows=n grants=n indexes=n constraints=n owner=schema_owner
imp userid=user/pwd full=y indexfile=schema_owner.sql

This will create a file called schema_owner.sql with your DDL. You can strip out the "REM" text and you have a functional DDL build script for your tables and indexes.

Thomas