Assign tablespace for table that will be created dynamically

Question

I am creating an Oracle table dynamically but can not figure out how to assign the correct tablespace. We generally use three different tablespaces depending on table size. Does anyone know of a way to assign tablespace to a table that will be created during the Alteryx flow?

mceleavey · Accepted Answer

Hi @cca8380 ,

have you tried inserting a pre-sql statement into the output tool that includes the tablespace name?

For example:

create table tablename tablespace tablespacename
as select * from table2

You can then overwrite the statement elements using whatever logic by wrapping the output into a batch macro and feeding the tablespace names in as control parameters and overwriting the name in the hardcoded statement?

M.