Hi ,
I plan to reorganize all tables for particular application.what is the steps I have to follow.please reply.
Printable View
Hi ,
I plan to reorganize all tables for particular application.what is the steps I have to follow.please reply.
One method is:
1. Export
2. Drop
3. Import
2nd method is:
Move tables and indexes.
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 )