cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

best way to reorganize big tables like... 3G to 7G

Oracle = 9.2.0.5
Hp 11i

There are many ways to reorganize tables for defregmentation. What is the best way to reorganize big tables like... 3G to 7G

All Tables contain one of these columens:
-- Long, Raw Long, Bfile OR Blob.. --

Is this is the best way:
=======================
What are Advantage and Disadvantage of this method ?

create table FINANCE_New
tablespace FINANCE_tablespace
storage (initial new_initial next new_next
freelists new_freelist_number )
as
select * from FINANCE
order by primary_index_key_values;

===

create table FINANCE_New
tablespace FINANCE_tablespace
nologging
parallel 5
as
select * from FINANCE
order by empno;


Are this method take care of Indexes, triggers, view, procedures, Packages ETC.. ?

Are we need to build and compile..



What happen to

-Indexes
-Privilege
-Role Information
-triggers
-constraints



Thanks
M