Home > Ask the Oracle Database / Applications Experts > Oracle database internals Questions & Answers > How to free up more space for Oracle?
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

How to free up more space for Oracle?

Don Burleson EXPERT RESPONSE FROM: Don Burleson

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 18 January 2006
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).


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle database internals
How to find a dropped table?
Removing carriage returns at the end of clob fields
Finding length of numeric datatype field
Problem with incoming parameter in dynamic SQL statement
Reading WSID from back-end
Making a select statement faster
Select * from loc
Difference between 9i and 10g OCP exams
Concatenate values separated with commas
Error after installation of 9i on Red Hat Linux

Oracle database availability
Review: Oracle's 11g R2 database has some good and bad
Oracle releases new database, says 11g upgrade will cut costs
Firm dumps MySQL on Red Hat for Oracle Database on Oracle Linux
Data modeling tools no substitute for hard work
Oracle RMAN case study: Improving backup and recovery efficiency
Oracle and the rise of the virtual machine
Using connection load balancing with Oracle RAC
Grid computing adoption slow amid fears of complexity
DBA 102: Beyond the basics
Difference between Oracle RAC and Data Guard
Oracle database availability Research

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts