I believe you need to create the USERS tablespace first before you specify "DEFAULT TABLESPACE USERS" in the create script.

Does the trace file mention anything about the USERS tablespace?