Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00907: missing right parenthesis while creating the table with datatype timestamp (oracle 9.2.0.8 sun os)
ORA-00907: missing right parenthesis while creating the table with datatype timestamp [message #407444] Wed, 10 June 2009 03:52 Go to next message
rajabaskar
Messages: 13
Registered: June 2007
Location: chennai
Junior Member
While i am creating a table throw the ORA-00907 error.


create table raja.timestamp_test
( ts timestamp(6));
SQL> 2 ( ts timestamp(6))
*
ERROR at line 2:
ORA-00907: missing right parenthesis


SQL> create table raja.timestamp_test
( ts timestamp);
2 ( ts timestamp)
*
ERROR at line 2:
ORA-00902: invalid datatype.

I am able to create the same tables in another database.
Both databases ORACLE_HOME are same. Please suggest me.


BR
Rajabaskar

Re: ORA-00907: missing right parenthesis while creating the table with datatype timestamp [message #407449 is a reply to message #407444] Wed, 10 June 2009 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
select * from v$version;


Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: ORA-00907: missing right parenthesis while creating the table with datatype timestamp [message #407453 is a reply to message #407444] Wed, 10 June 2009 04:17 Go to previous messageGo to next message
rajabaskar
Messages: 13
Registered: June 2007
Location: chennai
Junior Member
Both databases running on 9.2.0.8.


Regards
Rajabaskar
Re: ORA-00907: missing right parenthesis while creating the table with datatype timestamp [message #407467 is a reply to message #407453] Wed, 10 June 2009 05:22 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post I asked, not what you think it is.

Regards
Michel
Previous Topic: merging of sql scripts
Next Topic: SQL
Goto Forum:
  


Current Time: Tue Feb 11 09:35:04 CST 2025