Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Location
    Mumbai, India
    Posts
    26

    Question Unanswered: Tricky question, asked in tech review.

    I am using Redhat Linux (RHEL 4) and Oracle 9i.
    If data file destination has no space to accomodate any new datafile, what should be the DBA's strategy? i.e. what should be done then?

    In case of OMF, if db_create_file_dest has no space to accomodate any new datafile, what should be the DBA's strategy? i.e. what should be done then?

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Plenty of options there. From NFS, attaching more storage to table compression perhaps ? It depends on the situation. Is this after a problem or a way of being pro-active ?

  3. #3
    Join Date
    Aug 2006
    Location
    Mumbai, India
    Posts
    26
    I am just going through company training and came across this problem.

  4. #4
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    A quick solution is to check how much actual space each tablespace needs for real data... then reorganize and resize. This might give enough room on the drive for a new tablespace... however, it is certainly not a long term solution.

    On RHEL4, you could always add more drives to the volume group...
    JoeB
    save disk space, use smaller fonts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •