Re: Silly question about export in Oracle 8

Im using exp80 like this:

exp80 userid=scott/tiger file=test.dmp full=y

C what I'm trying to do here is to take all of the tables under user CRITTER and put it in a nice, compressed DMP file to be use in a different machine.

Thank you
John Nunez

Sybrand Bakker wrote in message
<938724188.22703.0.pluto.d4ee154e_at_news.demon.nl>...
>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 Sun Oct 03 1999 - 14:34:13 CDT