Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Post import/export tasks

Re: Post import/export tasks

From: Joel Garry <joel-garry_at_home.com>
Date: 18 Apr 2006 14:24:20 -0700
Message-ID: <1145395460.738914.165310@g10g2000cwb.googlegroups.com>


>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.html
Received on Tue Apr 18 2006 - 16:24:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US