what is compatible set to?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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
>
>
>
Received on Wed Jul 02 2003 - 08:25:02 CDT
