It depends on the configuration. Our Oracle instances are configured to not allow index creation in the data tablespaces. The JForum installation script errored out when it tried to create the index in the "wrong" tablespace.
I believe there are a couple ways to solve this.
1) Add the explicit TABLESPACE param to the CREATE INDEX statements
2) add the USING INDEX TABLESPACE param to the CREATE TABLE statements
I chose option #1 'cause it was easy =) [originally posted on jforum.net by Anonymous]