Re: deprecated connect internal

But, that's what I said 'connect / as sysdba' - in fact thats all I said, no mention of system anywhere !!

Alex

Kevin A Lewis wrote in message ...
>The connect to SYSTEM will work as it is; however it is not 'the new
>method'. SYSTEM is a different user. If you wish to connect to SYS as you
>would have by using INTERNAL the replacement/equivalent command is 'CONNECT
>/ AS SYSDBA;'
>
>Well that's what I was told on my 'not too ancient' DBA oracle course and
>documentation and discussion I have read recently has confirmed. I am open
>to any informed correction as always.
>
>Regards
>--
>Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> <KevinALewis_at_HotMail.com>
>
>The views expressed herein by the author of this document
>are not necessarily those of BOCM PAULS Ltd.
>external-news <alex_at_alenda.freeserve.co.uk> wrote in message
>news:7n9apb$1uo$1_at_taliesin.netcom.net.uk...
>> So how is it not correct then ?
>>
>> Alex
>>
>> Kevin A Lewis wrote in message
>> <4cVl3.4171$N47.500_at_newreader.ukcore.bt.net>...
>> >I'm not sure that the last post is correct
>> >
>> >Oracle's new replacement for 'connect internal' is 'connect / as
sysdba'.
>> >This logs on as SYS as does INTERNAL and is equivalent. When you log on
>as
>> >SYSTEM you are on as a different schema owner, not the owner of the
>> >dictionary. You may want to log on that way but it is not the same as
>> >logging on as INTERNAL.
>> >
>> >Regards
>> >
>> >--
>> >Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich
>England)
>> > <KevinALewis_at_HotMail.com>
>> >
>> >The views expressed herein by the author of this document
>> >are not necessarily those of BOCM PAULS Ltd.
>> >Alex <alex.hudghton_at_capgemini.co.uk> wrote in message
>> >news:7n74uq$cs0$1_at_taliesin.netcom.net.uk...
>> >>
>> >> Anurag Minocha wrote in message
>> <379700F2.67625BC_at_synergy-infotech.com>...
>> >> >Hi,
>> >> >The Oracle8.0.5 documentation sayss that connect as internal has
>been
>> >> >deprecated and is being supported just for backward compatibality. I
>am
>> >> >using connect internal. Can somebody please help me out as to how to
>> >> >switch over to the new method. The documentation is quite confusing.
>> >> >Any help will be appreciated.
>> >> >
>> >> >Thanks
>> >> >anurag
>> >> >
>> >> >reply at
>> >> >anurag_at_synergy-infotech.com
>> >> >
>> >>
>> >> connect / as sysdba
>> >>
>> >> Alex
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
>
Received on Fri Jul 23 1999 - 05:40:37 CDT