James,
Sorry its taking so long to get back to you, for some reason the list emails were getting caught in my spam folder and I just got around to cleaning it out...
When setting up the CMS, there is a plugin you can get to in design mode called DBMigrate, you can run this plugin and it will create all of your tables for you.
I think the plugin works with Oracle but not 100% sure. If it doesnt, you can looking in the db/migrate folder and there are descriptions of all the tables. There should also be a mysql schema dump in the install folder as well that you could use to get the table definitions.