DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007

    cleaning up messy db

    I am in need of some help, I inherited a rather messy oracle database. some of the tablespaces have many many small datafiles. Could someone outline a procedure to consolidate these many small files into one large file, without taking the tablspace or the db offline? is this even possible.

  2. #2
    Join Date
    Jul 2002
    Northampton, England
    Was there any reason why your predessessor created lots of small datafiles? You might want to find that out before you do anything.

    Anyway, why don't you create new tablespace with larger datafile and move all the objects. Do you have any downtime?
    Assistance is Futile...

  3. #3
    Join Date
    Jun 2007
    The simple answer, they did not know what they were doing, once they created a smal file and every time they ran out of space, they just created another one of the same size, go figure???

    No, I do not have the luxury of any downtime, I have had a consultant reccomend to me that this is an easy thing to do while the DB is up so I thought I would ask.

    I was planning on doing this consolidation as part of a migration to new hardware and oracle 10g, currently running 9i. My plan was to build a new db and the tablepaces, import the rows and tables, apply the edited indexfile then be up and running, the consultant I think spooked my already juttery boss and recommended copying the db over and running the convert script for 10g, he said it won't take but an hour or two, I have my doubts, but that would leave me the eventual task of cleaning up the messy little files.


Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.