I use Oracle 8.1.7. I tried install patchset 8.1.7.3 and there is written:
" ...
Invoke SQL*Plus (sqlplus), connect as internal and run the following SQL
scripts with event 10520 set. NOTE: This event is not intended for regular
database operation and MUST be turned off as indicated below:
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';
?/rdbms/admin/catalog.sql
?/rdbms/admin/catproc.sql
?/rdbms/admin/catrep.sql
(This only needs to be run if you are using
symmetric/advanced replication. This is not necessary for sites using dblinks
and read-only snapshots if symmetric/advanced replication is not installed)
CONNECT / AS SYSDBA;
update obj$ set status=5 where type#=29 and owner#!=0;
commit;
..."
Excuse me for long quotation.
Why first "connect internal" and second "connect / as sysdba"? For a
multiplicity only ?
If it's not, what's difference between thease?
> 'connect internal' is no longer supported in 9i+
>
> 'connect / as sysdba' is the replacement.
>
> --- Mikhail Ivanov <[EMAIL PROTECTED]> wrote:
> > What is difference between "connect internal" and "connect / as
> > sysdba" in
> > sqlplus ?
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
--
Best regards
Mikhail Ivanov
>W���z�^���r&�9,B�m����(��ک�&�a��"����ڞ��4D�����]z���V�
+r5�p��z��q�<��w�9�m����ڵȭ��&I�É�(
+�b~�牣�X��X��������b����z��DCTL������ka�ɚ�X��X��ǧu��1����,j�����k����r+rr���ׄ\ �����)���Ѯ��v)�鞲Ơx�b)ܖ�^jX�y�'����x5%9,B��^�������X��X��*.�����ޭ騽�_�����ɩl�ǧv�^B�r��jw_��-����+��b�yb��.n�+���