Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Assign tablespace for table that will be created dynamically

cca8380
7 - Meteor

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?

1 REPLY 1
mceleavey
17 - Castor
17 - Castor

Hi @cca8380 ,

 

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

 

mceleavey_0-1681472078778.png

 

 

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.



Bulien

Labels
Top Solution Authors