Re: help with CREATE SYNONYM

sandra_at_muenster.com wrote:

> In article <38AAEFE1.7C70B268_at_fast.no>,
> kev <kevin.porter_at_fast.no> wrote:
> > I just tried doing the same thing, but as sys rather than user1 - it
> looked like
> Hi Kev,
>
> yes you're right, the option is full=y to get the data into
> the rows :)
>

Hmm, but if I try it I get this error:

IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

How do I workaround this?

thanks,

• Kev

>
> Sandra
>
> > 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,
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Feb 17 2000 - 00:00:00 CST