Re: Problems with TIMESTAMP on Oracle 9i

From: Eric Parker <eric.parker.spamless_at_virgin.net>
Date: Wed, 2 Jul 2003 14:12:20 +0100
Message-ID: <VSAMa.1030$ju6.8724@newsfep4-glfd.server.ntli.net>

"Ola Martin Lykkja" <lykkja_at_hotmail.com> wrote in message news:3f02d1f2$1_at_news.broadpark.no...
> Hi,
>
> I am running Oracle 9i on a Sun server.
>
> When I try to create a table containg a TIMESTAMP column I get this error:
> CREATE TABLE TEST1 ( c1 timestamp );
> ERROR at line 1: ORA-00902: invalid datatype
>
> Does anyone have a clue about what is going on?
>
>
> The output from 'select * from v$version' is:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE 9.2.0.1.0 Production
> TNS for Solaris: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
>
> Best regards,
> Ola Martin Lykkja
>
>
>

Martin

Cut & pasted from your message :

SQL> CREATE TABLE TEST1 ( c1 timestamp );

Table created.

SQL> select * from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production PL/SQL Release 9.2.0.2.1 - Production
CORE 9.2.0.2.0 Production
TNS for 32-bit Windows: Version 9.2.0.2.0 - Production NLSRTL Version 9.2.0.2.0 - Production

SQL> I wonder if you can get this if compatible is set 8.1.X ?

HTH eric Received on Wed Jul 02 2003 - 08:12:20 CDT