Re: Silly question about export in Oracle 8

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 - 12:54:14 CDT