Re: help with CREATE SYNONYM

From: kev <kevin.porter_at_fast.no>
Date: 2000/02/16
Message-ID: <38AAEE1A.F11100CC@fast.no>#1/1

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,

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