After setting up Oracle10g as the DefaultDS using this docs: http://www.jboss.org/file-access/default/members/jbossas/freezone/docs/Installation_And_Getting_Started_Guide/5/html_single/index.html#Configuring_a_datasource_for_Oracle_DB
and starting the AS instance with "all" config, this error occured:

07:21:29,553 ERROR [AbstractKernelController] Error installing to Start: name=jboss:service=KeyGeneratorFactory,type=HiLo state=Create mode=Manual requiredState=Installed
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
....

• • • CONTEXTS IN ERROR: Name -> Error
      jboss:service=KeyGeneratorFactory,type=HiLo -> java.sql.SQLException: ORA-00942: table or view does not exist

Similar thing happens with DB2 v9.