peter wrote:
> How can I exp the data where my following query is true:
>
> select d.deptno,dname,ename,sal,address from dept d,emp e where
> d.deptno=e.deptno;
>
> And Then how I imp the same data on client database in both tables.

Assuming 10g ... with DataPump.

For instructions on how to do this Read The Fine Manuals at
http://tahiti.oracle.com.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org