Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with TIMESTAMP on Oracle 9i

Re: Problems with TIMESTAMP on Oracle 9i

From: Brian Peasland <oracle_dba_at_remove_spam.peasland.com>
Date: Wed, 2 Jul 2003 13:16:42 GMT
Message-ID: <3F02DB3A.E4E663A4@remove_spam.peasland.com>


What is your COMPATIBLE parameter set to? Make sure it is set to at least 9.0.0.

Cheers,
Brian

Ola Martin Lykkja wrote:
>
> 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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Wed Jul 02 2003 - 08:16:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US