Table space in Oracle must be Drop along with data.
DROP:---
drop tablespace data1 including contents cascade constraint;
To check use below command
Check:--
select tablespace_name, file_name from dba_data_files;
DROP:---
drop tablespace data1 including contents cascade constraint;
To check use below command
Check:--
select tablespace_name, file_name from dba_data_files;
No comments:
Post a Comment