Q
Manage Learn to apply best practices and optimize your operations.

How to free up more space for Oracle?

I have a barcode application running on a Sun platform with Oracle9i. Oracle is 92% full. I have space in other locations. Is there any way to relocate/resize?

I have a barcode application running on a Sun platform with Oracle9i. Oracle is 92% full. I have space in other locations. I have the following output from dba_temp_files:
TbspaceNm   Bytes(1024/1024) location
temp2              9715       /oracle/..
temp               141        /oracle/..
system.dbf is located in /oracle path. Is there any way to relocate/resize, or what should I do? Please help me as our company does not have a DBA expert.
When you run out of space in a filesystem you have two choices:
  • Increase the size of the filesystem.
  • Move the datafile to another filesystem on a separate mount point.

If you want to move the tablespace you need to:

  1. Quiecse the tablespace (alter tablespace dba_temp_files offline).
  2. Copy the datafile to the new location.
  3. Rename the tablespace datafile "alter tablespace rename datafile /oracle/temp2 to /oraclenew/temp2."
  4. Bring the tablespace online (alter tablespace dba_tamp_files online;)
  5. Nuke the old file from the fileysystem (rm temp2).

Dig Deeper on Oracle database availability

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close