Re: TIMESTAMP datatype is invalid?

What is your COMPATIBLE parameter (select value from v$parameter where name = 'compatible';) ?

Is it release 1 or 2 ?

Do you have a Locally Managed SYSTEM tablespace ?

• Kenneth Koenraadt

On Thu, 16 Jan 2003 18:01:48 +0530, "Yash" <yashgt_at_yahoo.com> wrote:

>Hi,
>I installed Oracle 9i on an HP-UX 11 server. I then successfully created a
>database. When I tried to create a table with a column of type timestamp, it
>said the datatype is invalid. The command I gave was
>create table junk (x timestamp) ;
>The error, Oracle gave was ORA-00902.
>
>Is there some script that I have to run for Oracle to identify TIMESTAMP as
>a datatype?
>
>Thanks in advance
>Yash
>
>
>
>
Received on Thu Jan 16 2003 - 07:41:06 CST