Re: OT: Derby to Oracle

Probably what's failing you is the IDENTITY stuff.  Oracle doesn't have 
autonumber/identity so you'll have to create a sequence and set the 
default value of the ID column to sequence.nextval.

Also, replace VARCHAR with VARCHAR2.

-CB

Mike Seda wrote:
> All,
> Does anyone know how to port the following SQL statement (that currently 
> works in Apache Derby) to Oracle:
> CREATE TABLE SOMEDATABASE.SOMETABLE (
> ID BIGINT GENERATED BY DEFAULT AS IDENTITY,
> HEADER VARCHAR(255) NOT NULL ,
> LINKTEXT VARCHAR(255) NOT NULL ,
> URL VARCHAR(255) NOT NULL ,
> DESCRIPTION VARCHAR(255) NOT NULL ,
> DUEDATE DATE
> );
> 
> Mike
> 
> _______________________________________________
> Juglist mailing list
> [email protected]
> http://trijug.org/mailman/listinfo/juglist_trijug.org