Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Post import/export tasks
>By tasks i mean tasks like index reorganization.
If you grep the export file for "CREATE IND" you may see that the indices are created as part of the import. If you have time or undo constraints, sometimes it can be better to not create the indices until after you import the data. Either way, the indices are new so they don't need to be reorganized. Even in normal operations it is rare for indices to _need_ to be reorganized (massive deletes being a big exception).
Besides what the others said, there may be application specific tasks. There may also be other issues depending on the purpose of the import, as for example if you are upgrading or migrating.
jg
-- @home.com is bogus. These people might want to think about carryforward writedowns Novell may have that could help Oracle's tax situation, as well as the fact that Oracle needs a _server_ oriented Linux distribution: http://searchopensource.techtarget.com/originalContent/0,289142,sid39_gci1180607,00.htmlReceived on Tue Apr 18 2006 - 16:24:20 CDT