oracle table size

[mlybarger]

i'll probably get a few of the phrasing wrong here, but here goes. i'm moving from using postgresql as the jms data source provider to using oracle. i _think_ that jboss is unable to create the jms_messages table. in my server logs, i see a message such as:

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573).....

i look at my database schema and i see the jms_transactions table, but not the jms_messages table.

if i try to manually create the table as per the CREATE_MESSAGE_TABLE statement in the oracle-jdbc2-service.xml in the default/deploy/jms folder, i get the following message from oracle:

ORA-03237: Initial Extent of specified size cannot be allocated

are there any special parameters that my schema needs to be created with to be able to use this feature? space/size considerations? i asked for 100M of table space for my schema just to be on the safe side, but the actual data of my user tables is fairly small (currently < 300k)

btw, the forum search isn't working so nicely, and there's no forum about the forums themsselves that i can see.

[mlybarger]

it seems that the create table i'm trying to use isn't a valid oracle script:

CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL,
DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER,
TXOP CHAR(1),
MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) )

i don't see a oracle-jdbc2-service.xml in the examples, so i'm not quite sure where this came from. anyone have a valid example of an oracle-jdbc2-service.xml file?

thanks