Re: help with CREATE SYNONYM

I just tried doing the same thing, but as sys rather than user1 - it looked like it worked (the only errors I got were when trying to create the tables but they already existed because of my last attempt), but there is still no data in the tables.
What is the parameter I need to give to imp to get it to import the data? There is a TABLES parameter, but do I really need to use this and specify every single table?!?
There is also a FULL parameter, should I be using FULL=Y?

thanks,

• Kev

kev wrote:

> OK thanks,
>
> I did an exp (in interactive mode) on the remote machine and chose to export
> a user (user1).
> Then I copied the expdat.dmp file to my local machine, then did:
>
> imp fromuser=user1 touser=user2
>
> but I got allsorts of errors, here's a snippet:
>
> import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
> set
> export client uses US7ASCII character set (possible charset conversion)
> export server uses US7ASCII NCHAR character set (possible ncharset
> conversion)
> . . importing table "CATEGORY"
> IMP-00058: ORACLE error 1552 encountered
> ORA-01552: cannot use system rollback segment for non-system tablespace
> 'USERS'
>
> The tables themselves seem to have been created but there is no data in them.
>
> What have I done wrong?
>
> thanks,
>
> - Kev
>
> Daniel wrote:
>
> > 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