How to drop datafiles after droping schema from database
Hi
can any one please suggest me.
i have one production database which size 300gb in that database having 3 db schema
out of three schema 1 schema size is 180GB it contain 30 datafiles, this schema present in USERS tablespace.
now i am plan to drop this schema whose size is 180gb after droping schema how can i drop the datafile(how do i understand datafile which not cantain any data i.e the file is OK to delete or dropped)
because i need to minimize database size
please suggest me the steps that need to follows.
i need to shrink tablespace
Regards