Connecting Tech Pros Worldwide Help | Site Map

Oracle exp tool

Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 292
#1: Oct 18 '09
Hi

I wonder if oracle gives a tool similar to exp but which would
1) get a list of tables wich are connected by foerign keys constraints (i know exp does)
2) get a 'where query for one table' lets call it X table (i know exp does)
3) export rows form X which filfull given where clause
4) export all rows form the other tables wich are connected with exported rows from X (i think exp can't do that).

I write a plsql package which almost do that export but wonder if there is some soft which do that.
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,504
#2: 4 Weeks Ago

re: Oracle exp tool


it is always better to write your own customized routine for such specific requirement.
Reply