Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export tables with NT
Hi There,
How about removing the parfile parameter from within the parfile...
In article <80ftc0$qoj$1_at_nnrp1.deja.com>,
Vivi <vivianegm_at_my-deja.com> wrote:
> Sir's,
> I have a Oracle Database running under a Windows NT server.
> I've needed to export just one table named CONSUMO created by Rodrigo
> (Rodrigo just has CREATE
> SESSION AND CREATE TABLE system privs) . I have EXP_FULL_DATABASE /
> IMP_FULL_DATABASE / DBA
> roles .
> Then i tried to use the exp80 in table mode to perform this task.
> CONSUMO table doesn't have no kind of index!
> Created a parfile with this content:
> grants=y
> file=exp1.dmp # without full path
> log=exp1lg.log # '' '' ''
> parfile=parexp1.dat # '' '' ''
> rows=y
> tables=(Rodrigo.consumo)
> ######################
> dos prompt:
> c:\> exp80 vivi/password parfile=parexp1.dat <enter>
>
> The error generated by exp80 didn't report me clues:
> LRM-00112:MULTIPLE VALUES NOT ALLOWED FOR PARAMETER 'GRANTS'
> LRM-00113:ERROR WHEN PROCESSING FILE 'PAREXP1.DAT'
> LRM-00113:ERROR WHEN PROCESSING FILE 'PAREXP1.DAT' --> 2 x
>
> If i place the grant parameter to the end of the list in the parfile
the
> error pass to the next
> parameter (file..) and so on.
>
> Thanks in advanced. Viviane
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 12 1999 - 09:40:55 CST