Toad World® Forums

TABLESPACES: how to make them?


#1

hello,

I am a new user still digging through “getting started” videos. I can not find any clue about how to define a TABLESPACE and its STORAGE/DATAFILES definitions. I can see that a table can be placed in TABLESPACE but the “definition” of the latter is restricted to its name.

is there any way to include/generate in the final script real definition of the TABLESPACE instead of its name only?

thank you,
geos


#2

Hi,

you can write definition to Before Script section in Model Properties. Click Model | Model Properties and click tab Before Script.

Regards,

Vaclav


#3

Vaclav, do you mean writing the definition of the tablespace as it would be written as an SQL script?

if so, do you plan to add this feature (ie. tablespace definition) as a “clickable” feature, not copy-your-sql-script-here feature?

thank you,
geos


#4

Hi,

yes, it has to be written as SQL script. Currently we do not plan to make a clickable feature, but I created new CR for this requirement.

CR#80309

Regards,

Vaclav