Re: IMP/EXP accross platforms: What will be missing?

Hi,

Objects are created before the import, no grant problems (step 5). Why do you think that FTS will run faster if you import objects serially ?

Dias

Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<3indqv4vemr6pe9ppucnn38cun2ql28f7c_at_4ax.com>...
> ydias_at_hotmail.com (dias) wrote:
>
> >Hi,
> >
> >Your plan seems good, but it could take a long time to export and
> >import 230 GB.
> >You could try to parallelize this operation by exporting and importing
> >users rather than doing just one full export and import.
>
> Yes, good hint. On the other side, some degree of fuss may be
> introduced here. What about a user's grants on other users' objects?
> Schemas are not completely independent.
>
> I am afraid that the limiting factor will be the network transfer rate
> anyway. And I am wondering if this parallel input into the DB won't
> physically shuffle data extents from different segments randomly,
> which would be bad for full table scans later (assuming the schemas
> being loaded in parallel reside in the same tablespace).
>
> I can't wait to begin testing!
>
> Bye
> Rick Denoire
Received on Tue Nov 04 2003 - 09:19:29 CST