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

Home -> Community -> Usenet -> c.d.o.server -> Re: importing multiply user schemas

Re: importing multiply user schemas

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Tue, 6 Nov 2001 13:11:59 -0600
Message-ID: <9s9cgv$3pb$1@news.gte.com>

The parenthesis is a shell special character, so you must either escape the open and close paren or put the fromuser/touser in a parfile and reference this on the command line as parfile=<somefile>.

Escaped command line:

... fromuser=\(scott,fred\) touser=\(joe,ted\)

-Kevin

"Cameron Abbott" <cvabbott_at_altavista.com> wrote in message news:9s93t6$rem$1_at_bcarh8ab.ca.nortel.com...
> Hi all,
>
> I am trying to do an import of more than one user but I receive a syntax
> error. According to the server utilities guide (2-24) the syntax is:
> fromuser=(scott,fred) touser=(joe,ted) When I use this I get the error
> syntax error: `(' unexpected. Here is my import command : imp
> system/manager fromuser=(isd_admin,isd_user) touser=(isd_admin,isd_user)
> file=rps_export.dmp indexfile=rps_index.sql buffer=20000000 log=imp.log
>
> Any suggestions?
>
> Cameron
>
>
Received on Tue Nov 06 2001 - 13:11:59 CST

Original text of this message

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