Re: Migration of HTMLDB 2.0 to APEX 2.2

"Franz Langner" <franzlangner_at_gmx.de> wrote in message news:eelih4$6um$1_at_newsreader2.netcologne.de...
>
> Hi Matthias,
>
> we've done this just a couple of days before:
> The Job was migrating a middlerange HTMLDB - Instance from 9.2.0.7 to 10g.
> 9 Tablespaces, about 20 Apps, Datavolume nearby 4 G,
> charactersetconversion included.
> The old one was running on SUSE 8.2 PRO , the new one hides in a SLES9
> SP3.
> Here's a short description what to do:
>
> - you can lift up the existing htmldb 2.0
> - after doing this, export the existing workspaces with workspace export
> assistant. ( this has to be done, otherwise you won't get stable security
> for your applications )
> - export each application because their logic does not reside in the
> user-scheme
>
> - create the necessary tablespaces w datafiles on 10g-instance ( named
> FlOWS_XXXX )
> - install the fresh apex 2.2 on the 10g( neither using sysaux I've choosen
> a tablespace apex/apex-Files for it)
> - import the workspaces with workspaces import assistant
> - import each application from its sqlfile, one by one ( use sqlplus
> commandline as FLOWS_020200 for doing this )
> * after this your security mechanism is working and your application logic
> is working
> - now you can do exp/imp on the schemas from the old to the 10g.
> * this will bring in your data and business-logic towards your
> application.
> We did not notice any issues after that kind of upgrade.
>
> You'll get further compentent hints on forums.oracle.com , lookin in the
> Application express-forum.
>
> Regards Franz
> franzlangner_at_gmx.de
>

Thanks a lot for the feedback, appreciated !!

Cheers
Matthias Received on Mon Sep 18 2006 - 13:02:52 CDT