Problems with TIMESTAMP on Oracle 9i

From: Ola Martin Lykkja <lykkja_at_hotmail.com>
Date: Wed, 2 Jul 2003 14:35:16 +0200
Message-ID: <3f02d1f2$1@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 Received on Wed Jul 02 2003 - 07:35:16 CDT