Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Tablespace Reorg to reclaim Space....

Shahzad.khanFeb 15 2016 — edited Feb 16 2016

Dear Oracle Experts,

We are Currently working on Oracle EBS R12.1.3 application with 11.2.0.2 database Linux environment. We are having a issue for database growth, now the disk space is almost full.

Some tablespace are growing very fast and the only solution is to reclaim the database are to reorganized a big tablespace.

For example: APPS_TS_MEDIA tablespace are having 08 data files with each datafiles are 20 GB size. Now 07 datafiles are full with maxsize and today I have added one more datafile with 10

GB Space.

How to reorganized the tablespace and reclaim the space. Kindly guide me steps by steps.

Regards,

shahzad

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2016

Added on Feb 15 2016

#general-database-discussions

21 comments

4,199 views