Re: How to move tablespace from IASDB to Ora92

"Les Noll" <lnoll_at_netnitco.net> wrote in message news:<d4%Pc.107$r_1.46801_at_newssvr28.news.prodigy.com>...
> We have Oracle 9.2 and Application Server. We got our Oracle server
> delivered with the user tablespace in the app server database (IASDB).
> We would like to move this out to a database of its own. I believe it is
> correct to say there is not currently an Oracle database on the
> machine, other than the app server db. How would I go about doing this?
> Thanks for the help.
> +Les

There are documents on metalink explaining how to do this (Ana and Hans are correct, too, you have to do it from the beginning), but there are performance issues that come up if you do - you have to use dblinks to access the data and you wind up waiting while the midtier talks to the infrastructure db which talks to the database which takes its time about talking back, then talks back with an attitude, then it all has to propagate back. Meanwhile, the user is wondering why it takes minutes after they press the "next page" button, when the old client/server app was instantaneous. Then they get a stall timeout, so you have to start reconfiguring xml files... In the end, you need to keep the portal repository in the same database as the user data, so you might as well leave it in iasdb if it is working.

There are platform dependant issues, too. Different, but not necessarily better, in 10g.

The whole configuration is very fragile and difficult to change. And the transport sets (portal exp/imp layered on "regular" exp/imp) have bugs, too.

jg

--
@home.com is bogus.
The penguin on top of your computer monitor will now explode. 
http://www.newsforge.com/article.pl?sid=04/07/30/1419205