Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Silly question about export in Oracle 8

Re: Silly question about export in Oracle 8

From: John N <jn14624_at_erols.com>
Date: Thu, 30 Sep 1999 16:33:27 -0700
Message-ID: <7t0h2j$kic$1@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 - 18:33:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US