Friday 25 November 2016

Drop tablespace in Orcale | DROP TABLESPACES in ORACLE INCLUDING DATA

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;


No comments:

Post a Comment