Simple is to replace DefaultDS with an Oracle-ds. You would become trouble if you use a XAdatasource.
Because JBoss messaging cant create the tables during startup because of transaction handling.
If you change deploy/messaging/hsqldb-persistence-service.xml with oracle one (see docs/examples) you should can create the tables with the SQL statements inside.
Other dependencies to DefaultDS I remove, see http://community.jboss.org/wiki/JBoss5xTuningSlimming