Re: Designer 6i migration on NT

Since I have not installed the upgrade and done the migration, I based the 'release 4.4 is significantly different than 4.3.' conclusion on the fact the documentation is significantly different between the two releases.

Thanks for the suggestion, and I will use one designer tablespace, designer index table and designer temporary tablespace, just as I have done in the past with several iterations of Designer I have installed.

Any thoughts about how Oracle would know which tablespaces to use if I used their scheme? Just curious.

"Gerard H. Pille" <ghp_at_skynet.be> wrote in message news:3DD1A490.90001_at_skynet.be...
> 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.
>
> 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
>
Received on Wed Nov 13 2002 - 22:02:26 CET