 export with multiple queries [message #124710] |
Tue, 21 June 2005 00:54  |
resy
Messages: 86
Registered: December 2003
|
Member |
|
|
I can export into tables with a single query in the parameterfile.
eg: exp scott/tiger file= emp.dmp tables= table_list.txt parfile=queries.txt
Can i have all the table names in table_list.txt
and respective queries for the tables in queries.txt?
table_list.txt
--------------
table1,table2,table etc
queries.txt
-------------
select * from table1 where ....
select * from table2 where table1.id = table2.id ....
select * from table3 where ...
Can i have multiple queries for different tables in a single file like this??
|
|
|
|
| Re: export with multiple queries [message #125514 is a reply to message #124710] |
Mon, 27 June 2005 03:37  |
munishmsh
Messages: 15
Registered: May 2005
Location: Bangalore
|
Junior Member |
|
|
Yes, Multiple queries can be loaded through SQL Loader but the where clause needs to be same.
Like,
exp scott/tiger TABLES=emp,bonus QUERY=\"WHERE job=\'SALESMAN\' and sal\<1600\"
Again, the SQL statements that Export executes are similar to the following:
SELECT * FROM emp WHERE job='SALESMAN' and sal <1600;
SELECT * FROM bonus WHERE job='SALESMAN' and sal <1600;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
