Results 1 to 15 of 15
  1. #1
    Join Date
    Dec 2011
    Posts
    11

    Unanswered: how to reorg table with large data type

    Hi want to reorg a table but it has a long data type?
    how is this possible?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Why do you want to "reorg" the table (whatever that should mean).

    And LONG as been deprecated since Oracle 8, why do you still use it?

  3. #3
    Join Date
    Dec 2011
    Posts
    11
    Thnx for the reply

  4. #4
    Join Date
    Dec 2011
    Posts
    11
    My db is oracle 10

  5. #5
    Join Date
    Dec 2011
    Posts
    11
    ALTER TABLE table_name MOVE;

  6. #6
    Join Date
    Dec 2011
    Posts
    11
    it works fine with all table except one that has one defined as long data type
    what's possible way to reorg that table?

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    what's possible way to reorg that table?
    Switch to a CLOB column, get rid of the deprecated LONG column.

    Why do you think you need to "reorg" the table?

  8. #8
    Join Date
    Dec 2011
    Posts
    11
    this is a live system db was up and running more than 3 years

  9. #9
    Join Date
    Dec 2011
    Posts
    11
    so purge table and now contain only one year data but still size is same

  10. #10
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by oracledlg View Post
    this is a live system db was up and running more than 3 years
    So what?
    Why do you think you need to "reorg" the table?

  11. #11
    Join Date
    Dec 2011
    Posts
    11
    i reorg other table
    as ex table size was 36gb after reorg 18gb
    mentioned table size 13gb

  12. #12
    Join Date
    Dec 2011
    Posts
    11
    hope all process will speed up after reorg

  13. #13
    Join Date
    Dec 2011
    Posts
    11
    is there possible way to reorg this?

  14. #14
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by oracledlg View Post
    is there possible way to reorg this?
    Switch to a CLOB column, get rid of the deprecated LONG column.

  15. #15
    Join Date
    Dec 2011
    Posts
    11
    how i can do that?

Posting Permissions

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