How to change default tablespace of self

Hi

Im trying to create tables of one "create_tables" script file in one tablespace and that of another "create_tables" script in some other tablespace. At the same time i do not want to hardcode the tablespace clause in the "create_tables" scripts. Im able to create tables in both tablespaces by hardcoding the tablespace clause. Is there any command in SQLPLUS which would create tables in some specific tablespace without having to specify it in the create table statement. Ive also tried the "alter user default tablespace" but i donot have DBA rights.

thanks in advance
Praveen Received on Sun Oct 16 2005 - 10:52:23 CDT