I'm writing a schema for automation of a tablespace creation, and I want to (at the beginning) check if it exists, then drop it if it does prior to creating it.
My question is how do I determine if the tablespace exists? (top part). I've been researching this for an hour now and can't find documentation on the sys schema.
WHERE name = 'my_table_space_name')
DROP TABLESPACE my_table_space_name INCLUDING CONTENTS;
CREATE TABLESPACE my_table_space_name
Thanks in advance for your help !!