I am trying to run a script to set up the apache roller db for blogging. When running the whole script I kept getting this error. So I tried just running the first table creation and I still get the error. So I thought I'd type it out instead of importing the script and I still get the error. This is exactly what I typed out and I get the error:
[Error] Script lines: 1-546 ------------------------
ORA-00911: invalid character
create table rolleruser (
id varchar(48) not null primary key,
username varchar(255) not null,
passphrase varchar(255) not null,
fullname varchar(255) not null,
emailaddress varchar(255) not null,
datecreated timestamp not null,
locale varchar(20),
timezone varchar(50),
isenabled number(1) default 1 not null
);
Is there something wrong with that statement?