Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to use exp/imp only for specific columns?
Sorry. I didn't catch that part of the posting. Please ignore my post.
Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX
simmons_mark_at_yahoo.com (Mark) wrote in message news:<5366fb41.0403240855.402c6025_at_posting.google.com>...
> Andreas,
>
> I think I read that the "COPY" command in sqlplus was going away in
> 10g. That's too bad. It was great for little one-off jobs like this.
>
> If you have 9i or below you can still schedule it this way:
>
> /* I believe remotedb must be in your tnsnames.ora file. */
> sqlplus user/pass_at_localdb <<EOF 1> logfile 2>&1
> sql> set copycommit 100;
> sql> set long 1000000; -- only necessary if you are copying a long
> value
> sql> copy from remotedb append tab2(b_key, b_val2) using select a_key,
> a_val2;
> EOF
>
> Mark Simmons
> Sr. Oracle DBA
> Sabre-Holdings, Southlake, TX
>
>
> alederer <alederer_at_gmx.at> wrote in message news:<40616570$1_at_e-post.inode.at>...
> > hallo!
> >
> > i have for example the following situation:
> >
> > a table on site a tab1(a_key integer,
> > a_val1 varchar(500),
> > a_val2 varchar(1000))
> >
> > and a table on site b tab2((b_key integer,
> > b_val2 varchar(1000),
> > b_val3 integer)
> >
> > is it possible to use the export/import utility or the sql loader to
> > transfer only the data of the columns a_key and a_val2 from tab1 to
> > tab2(into b_key, b_val2)?
> >
> > in the documentation of export, i have only found the QUERY parameter,
> > but it can only limit the rows not the columns which should be exported.
> >
> > if i have a direct database connection i can use
> > "insert into tab2(b_key,b_val2) (select a_key, a_val2 from tab1)"
> >
> > but how can a make this with export/import utility or sql loader?
> >
> > what i need is a way to export only specific columns of a table and to
> > import these export into tables with different column names and order.
> >
> > where can i find the missing information?
> >
> > thanks
> > andreas
Received on Thu Mar 25 2004 - 13:50:30 CST
![]() |
![]() |