In article <953klg$hnv$1_at_nnrp1.deja.com>,
gorgos_at_my-deja.com wrote:
> Hello all,
> I've inherited an application that has a schema called sysdba! I've
> also got a user who wishes to be able to login as sysdba using SQLPLUS
> 8.1.5 but he gets the error:
>
> SP2-0306: Invalid option.
> Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
> where <logon> ::= <username>[/<password>][@<connect_string>] | /
>
> Is there any way around this ? svrmgrl is not an option, as he can't
> access the server.
>
> This apparantly works in 8.0.4.
>
> Thanks
>
> Sent via Deja.com
> http://www.deja.com/
>
create a new user without reserved words in it,export the sysdba data
and use the fromuser touser route in imp.
--
Sybrand Bakker, Oracle DBA
All standard disclaimers apply
------------------------------------------------------------------------
Sent via Deja.com
http://www.deja.com/
Received on Mon Jan 29 2001 - 06:06:43 CST
