Re: help with CREATE SYNONYM

CREATE SYNONYM will not work in this way. Just export schema for user1, create user2, imp the datafile using user2/password_at_instance and use FROMUSER AND TOUSER. Daniel
Austin, TX

"kev" <kevin.porter_at_fast.no> wrote in message news:38AADED5.DFB579F9_at_fast.no...
> Hi,
>
> Here's what I want to do - I want to make a copy of all the tables for
> one user (user1) from a remote machine to my local machine.
> I plan to use exp to export a whole user. The sticking point is that I
> want all the tables to belong to a different user (user2) when I
> reconstruct the data with imp.
> So I thought I should probably just make a synonym 'user1' for user2 on
> the local system, then import the data as normal.
>
> Am I taking the right approach or is there an easier or more obvious way
> I should be doing this?
> If this is the right way to do it, will this CREATE SYNONYM command
> work?:
>
> create synonym user1
> for user2;
>
> thanks in advance,
>
> - Kev
>
>
Received on Wed Feb 16 2000 - 00:00:00 CST