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)
Partitioning in standard tables to improve performance. (2 Merged) [message #583196] Fri, 26 April 2013 23:24 Go to next message
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
Re: Oracle partitioning [message #583197 is a reply to message #583196] Fri, 26 April 2013 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 23026
Registered: January 2009
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/
Partitioning in standard tables to improve performance. [message #583198 is a reply to message #583196] Fri, 26 April 2013 23:38 Go to previous messageGo to next message
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
Re: Oracle partitioning [message #583199 is a reply to message #583197] Fri, 26 April 2013 23:40 Go to previous messageGo to next message
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.
Re: Oracle partitioning [message #583200 is a reply to message #583199] Sat, 27 April 2013 00:16 Go to previous messageGo to next message
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 Go to previous message
BlackSwan
Messages: 23026
Registered: January 2009
Senior Member
Partitioning is NOT the remedy for all & every performance problems.
Previous Topic: Oracle apps 12.1.3 functional knowledge
Next Topic: Oracle forms
Goto Forum:
  


Current Time: Fri Nov 21 13:27:49 CST 2014

Total time taken to generate the page: 0.12838 seconds