RE: Extra Columns to be added in Oracle Base Table
- From: Shyam Kumar <shyam4558@xxxxxxxxxxx>
- To: ora-apps dba <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Wed, 24 Jun 2009 19:32:35 +0000
Never do it, unsupported
Create a custom table to store what ever you want, don't touch the BASE table.
Let us know what u finally did
:)
Date: Tue, 23 Jun 2009 13:28:31 +0530
Subject: Re: Extra Columns to be added in Oracle Base Table
From: amit.dhingra77@xxxxxxxxx
To: ora-apps-dba@xxxxxxxxxxxxx
Yes It's an EBS table (Order Management)
WSH_NEW_DELIVERIES
there are 15 Attributes, I need to add 5 more.
one way is I design a custom table and make the relation with the base table.
Other way is I add 5 columns directly to base table and make a custom form,
which is easy to do and fast. Only if the same is the right approach.
When I am not at all hamering the existing columns why adding extra columns
with xxprefix not recommended (If not). Please suggest
Regards,
Amit
On Tue, Jun 23, 2009 at 1:15 PM, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
wrote:
Hi,
Saying "one of the oracle base table" are you talking about one EBS
tables installed initially?
What is the table name? Generally speaking it isn't supported at all.
It is less harmful to create a custom table in you custom schema
XX____ as you can't predict any impact on adding new columns to am
embedded table. Anything can go wrong starting from patching and
future upgrades ending with data corruption.
Yury
On Tue, Jun 23, 2009 at 5:38 PM, Amit Dhingra<amit.dhingra77@xxxxxxxxx> wrote:
> Hi ALL,
>
> I need to add 5 extra columns (Attributes) on one of the oracle base table.
> I am using the custom form based on oracle base table.
>
> Just wanted to know is it the right approach.
>
> Any suggestions?
>
> Regards,
> Amit
>
>
> On Tue, Jun 23, 2009 at 12:59 PM, Harish Muramshetty
> <harish.muramshetty@xxxxxxxxx> wrote:
>>
>> Hi DBA's,
>>
>> We are running 11.5.10.2 on 10.2.0.3 (HP-UX)
>>
>> Recent changes : Apps pwd changed through FNDCPASS
>>
>> When trying to open forms for the first time...Java initiator takes more
>> time (5 -10 mins) which was not earlier.
>>
>> Issue is happening for all users with all forms.
>>
>> But once java invokes and open the forms..then on..No issues...everything
>> is perfect...no perfomance issues.
>>
>>
>> Any Suggestions ??
>>
>>
>>
>> Thanks,
>> Harish.
>
--
Jurijs
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
_________________________________________________________________
Missed any of the IPL matches ? Catch a recap of all the action on MSN Videos
http://msnvideos.in/iplt20/msnvideoplayer.aspx
Other related posts:
