Re: Failed to create a type on Oracle 8?

Sorry I can't answer your question – I'm struggling with Oracle8 on NT and it sounds like you got further than me - can you help?

I can't create an instance (other than the default one) and see it.

I've just installed Oracle 8.0.3.0.0 on a clean NT (sp3) machine and the default
instance works fine (including ODBC over TCP/IP).

I use Oracle Database Assistant, choose "Custom Database", "Small" and choose all the defaults - I create database files from scratch ie I don't use the "copy from CD option" .

Using Instance Manager (oradim80) I can see the new Services "Started" and Instance
"Started".

When using Net8 Easy Config to create a Service Name to the new SID it says...

ORA-12505: TNS listener could not resolve name etc.

I can create a service name (using Net8 easy config) linked to SID=ORCL but not my new Instance.

hope_smith_at_hotmail.com wrote in article <6qpr2c$h1s$1_at_nnrp1.dejanews.com>...
> Login as scott/tiger,
>
> Tried to create a VARRY type, but oracle seems do not the end of
creation.
> Connected to:
> Personal Oracle8 Release 8.0.3.0.0 - Production
> With the Partitioning option
> PL/SQL Release 8.0.3.0.0 - Production
>
> SQL> create type prices as varray(10) of number(12,2);
> 2
> 2 ;
> 3 ;
> 4 ;
> 5
>
> Asking for help.
>
> Thanks.
>
> Hope
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Thu Aug 13 1998 - 08:30:10 CDT