- Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training


January 22, 2018, 06:49:44 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
   Home   Help Search Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: Steps to reorganize a tablespace in Oracle database  (Read 7710 times)
Posts: 0

« on: April 14, 2016, 12:28:59 PM »

Steps to reorganize a tablespace in Oracle database.


Step #1:
Shutdown the database and startup it with the ?restrict? option.
Step #2:
Since there is no space left on the pool, you will create a temporary tablespace (use create like of the tablespace in the subject) on a different pool which has enough space.
Step #3:
Grant quote to the user or users whom have objects on the tablespace.
Step #4:
Select the tablespace on the OEM and reorg the tablespace.
Wait until job gets completed; it may takes long, long, and long time and do not cancel the job.
Step #5:
Once the job is completed, drop the temporary tablespace.

Step #6:
Resize the tablespace.
Step #7:
Shutdown the database and startup the database without the restrict option; then email user or users.

Good Luck!
The iSelfSchooling Team
Pages: [1] |   Go Up
  Send this topic  |  Print  
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!