How could I save user input for datafile path in the variable TS_DIRECTORY (see below) and have Liquibase use that input in creation of tablespace?
The following two bolded lines cannot be used in Liquibase. There must be an argument that one could use in the properties file that passes the value to the tablespace statement in SQL. I have shown the tablespace statement within
PROMPT Enter the tablespace_dir (e.g.: F:\Oracle\xxx\yyyy)
accept TS_DIRECTORY char prompt 'Enter the tablespace dir: ’ default none
CREATE TABLESPACE some-name
‘&&TS_DIRECTORY/vvvvvv.dbf’ SIZE xxxM AUTOEXTEND ON NEXT xxxxM MAXSIZE UNLIMITED