-
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 )
siva prakash
DBA
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
|