Oracle partitioning for Peoplesoft Financials

From: Bob Robert <mssql_2002_at_yahoo.com>
Date: Wed, 7 Jun 2006 07:07:40 -0700 (PDT)
Message-ID: <20060607140740.11279.qmail@web38001.mail.mud.yahoo.com>

Gurus,

Did any one implement oracle 9i table partitioning in Peoplesoft Financials 8.8?

I have identified few tables for partitioning. They are PS_LEDGER, PS_JRNL_LN, PS_JRNL_HEADER and PS_LEDGER_BUDG. I am planning to use list partition by using business_unit or range partition by using fiscal_year.

Could you please share your experience for the following questions?

1) What are the tables you have implemented table partitioning?
2) What is the partition key and partition type?
3) Did you build any additional indexes?
4) Did you come across any issues after implementation?
5) Any tips, you could suggest for me.

Thanks,
Bob

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Wed Jun 07 2006 - 09:07:40 CDT