ORA-00907: missing right parenthesis while creating the table with datatype timestamp [message #407444] |
Wed, 10 June 2009 03:52  |
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
|
|
|
|
|
|