Re: Extra Columns to be added in Oracle Base Table
- From: Luis Freitas <lfreitas34@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 23 Jun 2009 10:54:14 -0700 (PDT)
Amit,
Altering the base table is a very bad idea.
If you add new columns, adpatch may fail on this table on every patch that
updates the ODF file that contains it. You will then have to maintain all the
tables and indexes on this particular ODF file manually, and this might be very
complex or even impossible.
Either create a new custom table to contain your fields and reference it to the
base table using the primary key or use a separating character to store several
fields on one attribute column.
Regards,
Luis
--- On Tue, 6/23/09, Amit Dhingra <amit.dhingra77@xxxxxxxxx> wrote:
> From: Amit Dhingra <amit.dhingra77@xxxxxxxxx>
> Subject: Re: Extra Columns to be added in Oracle Base Table
> To: ora-apps-dba@xxxxxxxxxxxxx
> Date: Tuesday, June 23, 2009, 4:58 AM
> 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
>
>
>
>
>
>
Other related posts:
