Re: To anyone with 9.2.0.5 or 10g...

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 23 Apr 2004 09:06:00 +0100
Message-ID: <4088ce68$0$26191$ed9e5944@reading.news.pipex.net>

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:c68s4g$tfm$1_at_nntp.fujitsu-siemens.com...
>
> "D Rolfe" <dwrolfeFRUITBAT_at_orindasoft.com> schrieb im Newsbeitrag
news:4087EECE.3000409_at_orindasoft.com...
> > Volker,
> >
> > It works for me with 9.0.1 and 10.1.0, but not 9.2.0.
> > Hope this helps...
> Thanks a lot!
> Now I only need a 9.2.0.5'er response...

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Apr 23 09:01:21 2004

ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name: niall/niall_at_nl9204

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production

NIALL 23-APR-2004 09:01_at_nl9204>create user volker identified by test 2 default tablespace users
3 temporary tablespace temp;

User created.

NIALL 23-APR-2004 09:01_at_nl9204>grant create session to volker;

Grant succeeded.

NIALL 23-APR-2004 09:02_at_nl9204>conn volker/test_at_nl9204 Connected.
VOLKER 23-APR-2004 09:02_at_nl9204>show release release 902000500
VOLKER 23-APR-2004 09:02_at_nl9204>select t1.table_name, t2.table_name

  2      from
  3          all_tables t1 full outer join all_tables t2 on (t1.table_name =

t2.table_name);

TABLE_NAME                     TABLE_NAME
------------------------------ ------------------------------
DUAL                           DUAL

<snip>

59 rows selected.

VOLKER 23-APR-2004 09:02_at_nl9204>

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/

Received on Fri Apr 23 2004 - 03:06:00 CDT