Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: importing multiply user schemas
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