I plan to reorganize all tables for particular application.what is the steps I have to follow.please reply.
One method is:
2nd method is:
Move tables and indexes.
just check if have any long columns in ur tables or nested tables .
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 )
Click Here to Expand Forum to Full Width