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