Our production db server mount points are 95% full.There are a few tables which are not required. Hence if I export those tables to our test db server and drop those tables, will it release space in production db server?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Short answer: probaply not. Longer answer: It depends. If they have their own tablespace and you drop the tablespace also, then yes.
If your test tables are in a tablespace that holds other data and you can‘t drop it then no. The Space is freed in the tablespace itself, but not on disk. To do that you need to reorganize the tablespace.
It depends on the database version and edition if you can do this online . Another option would be to create a new tablespace, copy all objects from the old tablespace into the new one.