how to reorg table with large data type

oracledlg · #1 (**permalink**) 12-16-11, 00:33

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

shammat · #2 (**permalink**) 12-16-11, 02:35

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?

oracledlg · #3 (**permalink**) 12-16-11, 05:31

Thnx for the reply

oracledlg · #4 (**permalink**) 12-16-11, 05:39

My db is oracle 10

oracledlg · #5 (**permalink**) 12-16-11, 05:40

ALTER TABLE table_name MOVE;

oracledlg · #6 (**permalink**) 12-16-11, 05:40

it works fine with all table except one that has one defined as long data type
what's possible way to reorg that table?

shammat · #7 (**permalink**) 12-16-11, 05:46

Quote:

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?

oracledlg · #8 (**permalink**) 12-16-11, 05:53

this is a live system db was up and running more than 3 years

oracledlg · #9 (**permalink**) 12-16-11, 06:07

so purge table and now contain only one year data but still size is same

shammat · #10 (**permalink**) 12-16-11, 06:07

Quote:

Originally Posted by oracledlg

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?

oracledlg · #11 (**permalink**) 12-16-11, 06:11

i reorg other table
as ex table size was 36gb after reorg 18gb
mentioned table size 13gb

oracledlg · #12 (**permalink**) 12-16-11, 06:12

hope all process will speed up after reorg

oracledlg · #13 (**permalink**) 12-16-11, 06:28

is there possible way to reorg this?

shammat · #14 (**permalink**) 12-16-11, 06:30

Quote:

Originally Posted by oracledlg

is there possible way to reorg this?

Switch to a CLOB column, get rid of the deprecated LONG column.

oracledlg · #15 (**permalink**) 12-16-11, 06:46

how i can do that?