Lars used to have this on his site, but it seems to be broken these days (he's into RoR lately). It generates the SQL code to create a tablespace and user in Oracle for OpenACS. This is a JS version so you don't have to worry about posting your particulars to my site. You can save a copy of this page locally too.
* You might want to use the same place as the existing files:
select file_name from dba_data_files;