SEO

#1 (**permalink**) 02-25-2008, 06:05 AM

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.

#2 (**permalink**) 02-25-2008, 06:05 AM

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.

You have no empno value in your result set, so I see no value in trying
to 'export' this data as you have no identifying field for the
employee. EMPNO is unique in the emp table (or so it is with the
sample data); to dump this subset of dept and emp data, with no way to
uniquely relate it to a specific employee, is folly.

Of course, if this is some gross oversimplification of your real issue
don't expect any useful responses; if you can't post the actual
problem, there is no use in providing any form of 'real' solution.

David Fitzjarrell

#3 (**permalink**) 02-25-2008, 06:06 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Query on 2 table while exp and imp (Join)