|
-
Table Reoraganization
Hi
I am planning to reorganize a table because of space problem and this has not been organized for the last 2 years.
Pls suggest me which way is a better/advantageous/safe one of
1) EXP/IMP or
2) DBMS_REDEFINITION.
My table got BLOB columns, This table is assigned to a specific table space which has got 65 datafiles of size 2GB each file, NO partitions but got Indexes. has a primary key but no foreign keys.
Pls suggest me a simple Idea/plan anybody
It's windows 2003 server with Oracle 10gR1.
and can not afford any down time
Thanks and regards.
BSR
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|