OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Partitioning in standard tables to improve performance. (2 Merged)

Home » Applications » Oracle Fusion Apps & E-Business Suite » Partitioning in standard tables to improve performance. (2 Merged) (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partitioning in standard tables to improve performance. (2 Merged) [message #583196]

Fri, 26 April 2013 23:24

bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi

Member

Hello friends

In oracle apps R12

I have 10g data base
and i want to do the partitioning on tables on the basis of year.
can anybody tell me ,how can i do it.and i have standard tables like ap_invocies_all ,ap_invoice_lines_all etc.

please tell me the partitioning process of one table on the basis of year.it will be very appriciable if u will help me

Thanks in advance
bhawna

Report message to a moderator

Re: Oracle partitioning [message #583197 is a reply to message #583196]

Fri, 26 April 2013 23:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post complete results from SQL below

SELECT * FROM V$VERSION;

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Partitioning in standard tables to improve performance. [message #583198 is a reply to message #583196]

Fri, 26 April 2013 23:38

bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi

Member

Hello friends

In oracle apps R12

and i want to do the partitioning on tables on the basis of year.
can anybody tell me ,how can i do it.and i have standard tables like ap_invocies_all ,ap_invoice_lines_all etc.

please tell me the partitioning process of one table on the basis of year.it will be very appriciable if you will help me

Thanks in advance
bhawna

Report message to a moderator

Re: Oracle partitioning [message #583199 is a reply to message #583197]

Fri, 26 April 2013 23:40

bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi

Member

hey Black Swan i have post another question.and all the version is defined over there.

Report message to a moderator

Re: Oracle partitioning [message #583200 is a reply to message #583199]

Sat, 27 April 2013 00:16

bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi

Member

I ve found a very nice link for that.
If anybody wants to know about that.u can go through that step by step process

http://www.runningoracle.com/product_info.php?cPath=63_89&products_id=373

[Updated on: Sat, 27 April 2013 00:16]

Report message to a moderator

Re: Oracle partitioning [message #583201 is a reply to message #583200]

Sat, 27 April 2013 00:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Partitioning is NOT the remedy for all & every performance problems.

Report message to a moderator

Previous Topic:	Oracle apps 12.1.3 functional knowledge
Next Topic:	Oracle forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 00:06:48 CST 2024