Re: Re-organize Oracle Application Database ( Oracle ERP Applications Release 10.7)

Hi!

I've got an O*A 10.7 running with a 7.3.4.5 DB on a unix-platform.

There is no problem to do changes with the DB. e.g move some DB-files, make an own tablespace for mtl_system_item. The application doesn't look at the DBstructure. It just want to find the components in the DB somewhere.....

Also tried to move some components from APPL_TOP to another disk and just make a softlink from APPL_TOP to this catalog (Done it with 'ar' and 'install' -catalog). This was no problem. The application runs as normal.

Audun

"Dhananjay Sen" <dhananjay_sen_at_hotmail.com> wrote in message news:2e5b0db8.0106110929.63eb964_at_posting.google.com...
> Hi
>
> All the datafiles of the Application Database corresponding to Oracle
> Applications release 10.7 were created in a single disk volume which
> has resulted into severe disk I/O and disk space problem for the
> Application Database .
>
> I need to move some of the datafiles of the Oracle Application
> Database ( Oracle Applications release 10.7) to separate disk volumes
> to overcome current space problem and I/O bottlenecks . without
> disturbing the currently running Oracle ERP Applications .
>
> Will the Oracle Applications ( Oracle Financials , Manufacturing etc.)
> get effected if the underlying data files of the Application Database
> are re-organized by moving datafiles to different disk volumes ? If so
> , what exactly I need to perform on the Oracle Application side so
> that it runs without problem after re-organization of its application
> database.
>
> Any help is highly appreciated . Thanks in advance
>
> Dhananjay Sen
Received on Tue Jun 12 2001 - 03:41:32 CDT