CREATE Table gives ORA-00904 error

Can anyone see what's wrong with this Oracle CREATE TABLE statement which gives me the above error. I also have this error whenever I use the 'New Table' wizard.

Is it possible that the reason I'm getting this error is because I don't have permissions to add a table to the database I'm working with. I do know that I am prohibited from adding a tablespace.

Thanks for your help
Matt

re: CREATE Table gives ORA-00904 error

Hi,

You have an Extra Comma After the UserID.. Remove that..
Also note the Primary key constraint..
Check here

Regards
Veena

re: CREATE Table gives ORA-00904 error

Why are you using all the double quotes and what is that GO in your code.

re: CREATE Table gives ORA-00904 error

OK, I tried using the info in that link to help but still no luck.

I get a 'missing or invalid option' error, both with and without brackets.
Can anyone help with this simple problem as I need it to create user security for my application!

The 'GO' has been taken from a previous SQL Server script and I believe is superfluous for Oracle.

Cheers
Matt

re: CREATE Table gives ORA-00904 error

I think you should give Sizes for your VARCHAR2 columns ....
e.g. VARCHAR2(30)

re: CREATE Table gives ORA-00904 error

Specify size of varchar2 field.