Hi ,
I have two table spaces ...Initially these were used for different companies.
Now, We don't need one of those companies. So, i wanted to delete the table spaces(files used by one of this table space).So that i can get some free space on my server
Will there be any Probem? and How to find out the files added to this table space( No Proper naming convention was followed to identify them easily)...

Thanks
Ram

As you didn't give that much details I can only tell you some headlines:

SQL> DROP TABLESPACE <tablespacename> INCLUDING CONTENTS;

is the command to drop tablespaces.

And:

SQL> SELECT tablespace_name, file_name
2 FROM dba_data_files
3 ORDER BY tablespace_name;

will show you the relation between tablespaces and datafiles. After dropping the tablespace the related files need to be removed from the OS.

As you show nearly any DBA knowledge I advise to let the real work be done by experts before you accidentally mess up your database.

Kind regards,
Dick

Hi Dick,
Thanks for the help


Ram