Below script will generate the DDLs of all the tablespaces in oracle.