Alfresco creates all the tables it needs during the bootstrap, provided the required schema already exists - you need to create that first. There is a script for that included in the distribution, though it may not be correct for Oracle.
Are you getting database related errors thrown during the bootstrap process? I set ours up to run against Postgres and the bootstrap failed repeatedly. The code actually creates the database initialization scripts in text files in a temporary directory and then tries to execute them. For some reason, on Postgres they were failing. The error trace included a line identifying the location of the script files and I was able to take a copy of them. I executed them manually through Postgres' equivalent of SQL*Plus and they worked fine. Then I started Alfresco again and the bootstrap ran to completion without error.
Martin Bradford
