Re: Silly question about export in Oracle 8

Hi John,
In that case, what is the exact error. IMO you still need to use FROMUSER=critter touser=(scott)

Regards,

--
Sybrand Bakker, Oracle DBA
John N <jn14624_at_erols.com> wrote in message news:7t0h2j$kic$1_at_autumn.news.rcn.net...
> Hi Sybrand,
> User scott has dba privileges. All I'm trying to do here is to gave scott
> not only access to the same tables that critters has but also make a
> separate copy of all the critter databases for scott to work on.
> Thank you again for all your help.
> John
>
>
> Sybrand Bakker wrote in message
> <938714138.12225.0.pluto.d4ee154e_at_news.demon.nl>...
> >You are connecting as user scott to export the user critter. If scott
> >doesn't have privilege to select from critter this won't work.
> >Also if you want to move the data from one user to another, that's
> >accomplished by imp fromuser= touser=
> >
> >hth,
> >
> >
> >--
> >Sybrand Bakker, Oracle DBA
> >John N <jn14624_at_erols.com> wrote in message
> >news:7svl5g$g2k$1_at_autumn.news.rcn.net...
> >> I've been using the export utility for a while, however I have a tough
> >> question:
> >>
> >> I use the following command in Oracle8 to export all table owned by
user
> >> critter to user scott:
> >>
> >> exp80 userid=scott file=critter1.dmp complete=y owner=(critter);
> >>
> >> but it does not work
> >> Any help please, thank you
> >> John N
> >>
> >>
> >
> >
>
>
Received on Thu Sep 30 1999 - 15:41:43 CDT