Re: Importing data onto existing table

"Sam Durai" <reachsamdurai_at_gmail.com> wrote in message news:1194391089.790974.130890_at_19g2000hsx.googlegroups.com...
> Good Evening, I'm just playing around in my oracle10g installation on
> AIX5.3.
>
> I have created 2 users named kimi and fred.
> Kimi owns the table kimi.f1_team
> fred owns the table fred.fred_f1_team
>
> Table strucure of kimi.f1_team and fred_f1_team is exactly the same.
> My intention is to populate fred.fred_f1_team table with kimi.f1_team
> data. But when I use imp utility it creates a new table fred.f1_team
> and loads it with data.
>
> Can you please help me to understand how to load existing table with
> data from some other table.
>
> Thanks,
> Sam
>

If the tablenames are identical you can use import with fromuser=kimi and touser=fred parameters.
Otherwise, you can simply use a sql statement: insert into fred_f1_team (col1,col,..)
select col1,col2, .. from kimi.f1_team

Make sure that fred has select privileges on kimi's table.

-- 
Terry Dykstra