Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: online reorg using dbms_redefinition

    Hi guys

    Running a 9i db. I wanted to see how easy it was to do some online reorg using the 'dbms_redefinition' package like for moving some datafiles to another filesystem volume e.g., (/ODATA)

    I've read online but was hoping for some more clear explanation...

    Regards
    Last edited by shajju; 07-11-09 at 10:56.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Running a 9i db
    This is the majority of your problem.
    Join the rest of Oracle community in the 21st century using supported versions with ASSM & LMT which do not tablespace reorganizations.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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