Re: Transportable tablespace, partition and existing functionality

Dear Listers,

Could you share some thoughts, please?

Best Regards,
AMIT On Fri, Jul 16, 2021 at 5:24 PM Amit Saroha <eramitsaroha_at_gmail.com> wrote:

> Dear All,
>
> We want to make use of transportable tablespaces and partitioning in our
> Oracle EBS environment to archive more than 7 years of old data and improve
> the performance in some areas. Please let me know if it makes sense to you.
> We don't want to buy third-party products to achieve our end goal.
>
> I am afraid that some processes where the optimizer is choosing FTS can
> impact because of this. I am also not sure about indexes and views
> dependent on tables as well.
>
> Kindly request you to provide me some insights on how to proceed with this
> analysis.
>
> Thank you in advance for your help.
>
>
>
> Best Regards,
> AMIT
>

--
http://www.freelists.org/webpage/oracle-l