reorg. table

[venkattr]

Hi ,
I plan to reorganize all tables for particular application.what is the steps I have to follow.please reply.

[tamilselvan]

One method is:
1. Export
2. Drop
3. Import

2nd method is:
Move tables and indexes.

[prakashs43]

just check if have any long columns in ur tables or nested tables .
my understanding
1) Long Columns are not moved .
2) export and import of nested tables doesn't work in some versions of oracle database .
3) check if all the proceduers are valid ( u may need to recompile )