I am getting an orcale error 911 when creating a table. Here is the log.oracle7 error:

message:2002-11-14[10:56:49]:E:701holla: ******* S T A R T of Error message *******
2002-11-14[10:56:49]:E:701holla: Log message called from /port.6.1c.06.04/vobs/t
t/servers/ORACLE_2/ora_native.c: #1991 keyword: Oracle Error
2002-11-14[10:56:49]:E:701holla: Pid 1448 Uid 6502 Euid 6502 Gid 125 Egid 125
2002-11-14[10:56:49]:E:701holla: user_type S language 2 user_name 701holla tty o
te locale ISO88591/NULL
2002-11-14[10:56:49]:E:701holla: Errno 25 (Inappropriate ioctl for device) bdb_e
rrno 0
2002-11-14[10:56:49]:E:701holla:
2002-11-14[10:56:49]:E:701holla: dbs_errno = 0Error 1911 occurred:
2002-11-14[10:56:49]:E:701holla: Error ORA-911 occurred during parse.
2002-11-14[10:56:49]:E:701holla: ORA-00911: invalid character
2002-11-14[10:56:49]:E:701holla:
2002-11-14[10:56:49]:E:701holla: Error BDB-1911 returned.
2002-11-14[10:56:49]:E:701holla: Parse error offset: 396, deferred 0
2002-11-14[10:56:49]:E:701holla: Info: peo 396, sql 52, oci 54, warn 0, osd 0, r
pc 0
2002-11-14[10:56:49]:E:701holla: See fatal SQL statement in '/apps/baan/baan4c3/
bse/log/log.ora.sql'.
2002-11-14[10:56:49]:E:701holla: Parse Group statement failed.
2002-11-14[10:56:49]:E:701holla: Flushed at /port.6.1c.06.04/vobs/tt/servers/ORA
CLE_2/ora_table.c : #878.
2002-11-14[10:56:49]:E:701holla: ******* E N D of Error message *******


Here is the log.ora.sql message:

------ Log Fatal SQL Statement -----
User : 701holla (pid 1448)
Date : 2002-11-14[10:56:49]
SQL :
CREATE TABLE baan.ttuddc920701 (t$tbnm CHAR(10) not null,t$fdnm CHAR(20) not nul
l,t$cvrc CHAR(10) not null,t$sedt DATE not null,t$setm NUMBER not null,t$eedt DA
TE not null,t$eetm NUMBER not null,t$sidt DATE not null,t$sitm NUMBER not null,t
$eidt DATE not null,t$eitm NUMBER not null,t$done NUMBER not null,t$Refcntd NUMB
ER not null,t$Refcntu NUMBER not null) pctfree 5 initrans 3 tablespace cmpny???_
data

We have a call into baan, but I thought I would check to see if someone knew of something we could check. When looking at the statements I see the cmpny???_data and it should be cmpny701_data.

Just looking for some clues.

Thanks

Mark

Hi Mark,

Maybe the entry for Company 701 has changed in the ora_storage file, and the tablespace name is incorrectly set to cmpny???_data

Cheers,

Hi James!

Thanks for the try, but we heard from Baan late yesterday. It turns out I fat-fingered a couple of capital letters into table field names. Once those were made lower cases I was able to create and allocate the table. I must have looked at this for 4-5 hours on wednesday and thursday, trying to figure out what was wrong with the table. Oh well.


Thanks again

Mark