Re: Designer 6i migration on NT

Bob Redding wrote:
> I have a Designer repository 6.0.3 that I am about to migrate to Designer
> 6i, release 4.4. The documentation requires you to do the migration between
> servers and not on the same server. I have set this up, and am getting
> ready to create the new empty repository (application wise) before I
> migrate. Oracle recommends a slew of tablespaces for the new repository
> whereas the old repository only had three tablespaces, the primary, index
> and temporary tablespaces.
>
> What the documentation doesn't tell me is how can I know what will be
> migrated to which tablespace?
>
> The old repository is on an 8.1.6 server and the new server is 9.2.
>
> Has anyone done such a migration? (Note that release 4.4 is significantly
> different than 4.3.)
>
>
>
>
Is it? I must have overlooked those differences.

[Quoted] Anyway, a lot of Designer's actions are based on sql-scripts, have a look in those, you should find your answer there.

But I think you could tell Designer to throw the lot together in one tablespace, I remember a form where you could specify loads of tablespaces. I have one for the tables, one each for large, medium and small indexes, and then some for blobs, clobs or whatever.

-- 

Gerard H. Pille