select tablespace_name from dba_tablespaces;select username from dba_users;select file_name from dba_data_files;select file_name,tablespace_name from dba_data_files; To check wether th tabl spacee ceated is alrerady present or not