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: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 30 Sep 1999 19:54:14 +0200
Message-ID: <938714138.12225.0.pluto.d4ee154e@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 - 12:54:14 CDT

Original text of this message

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