CODE EXAMPLE FOR SQL

how to get the ddl for datafile in oracle tablespace

SELECT DBMS_METADATA. GET_DDL('TABLESPACE','&TABLESPACE_NAME') FROM dual; --Example: --Enter the tablespace Name then it will get you the DDL for your tablespace.