In article <80ftc0$qoj$1_at_nnrp1.deja.com>,
Vivi <vivianegm_at_my-deja.com> wrote:
> Hi,
> I have an Oracle Database running under a Windows NT server.
> I've tried to export just one table named CONSUMO created by Rodrigo
> (Rodrigo just has CREATE
> SESSION AND CREATE TABLE system privs)and I couldn't do it . I have
EXP_FULL_DATABASE /
> IMP_FULL_DATABASE / DBA roles .
> Then I' ve tried to use the exp80 in table mode to perform this task.
> CONSUMO table doesn't have any 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 any 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 grants parameter at the end of the list in the parfile
the error passes to the next
> parameter (file..) and so on.
> Can anyone help me to solve this problem?
>
> 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 Sat Nov 13 1999 - 15:52:50 CST
