Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Oracle partitioning for Peoplesoft Financials

Bob Robert

2006-06-07

Replies:

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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.