Home » RDBMS Server » Performance Tuning » create dynamic partitions in oracle 9 (oracle9i/ windows)
create dynamic partitions in oracle 9 [message #397394] Fri, 10 April 2009 08:45 Go to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hi all
i need to partition my sales table with intervals of every three months...
can i create every three months

thanks
ram
Re: create dynamic partitions in oracle 9 [message #397395 is a reply to message #397394] Fri, 10 April 2009 08:48 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>can i create every three months
I give up. Can you?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.
Re: create dynamic partitions in oracle 9 [message #397398 is a reply to message #397394] Fri, 10 April 2009 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can... manually (or script).

Regards
Michel
Re: create dynamic partitions in oracle 9 [message #397399 is a reply to message #397398] Fri, 10 April 2009 08:52 Go to previous messageGo to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hi
i want create partitions in dynamic manner..
thanks
ram
Re: create dynamic partitions in oracle 9 [message #397401 is a reply to message #397399] Fri, 10 April 2009 08:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
parasuramchekuri wrote on Fri, 10 April 2009 15:52
hi
i want create partitions in dynamic manner..
thanks
ram

And your problem is?

Regards
Michel

Re: create dynamic partitions in oracle 9 [message #397402 is a reply to message #397394] Fri, 10 April 2009 08:57 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
I want it to stop raining.
Please assist.
Re: create dynamic partitions in oracle 9 [message #397403 is a reply to message #397401] Fri, 10 April 2009 08:59 Go to previous messageGo to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hi

My problem is

i am creating the partitions to my sales table to every three months...

if completes the tree months it will be created automatically for next three months....

thanks
ram
Re: create dynamic partitions in oracle 9 [message #397405 is a reply to message #397394] Fri, 10 April 2009 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Just precreate for next decade manually.
Re: create dynamic partitions in oracle 9 [message #397428 is a reply to message #397403] Fri, 10 April 2009 11:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
parasuramchekuri wrote on Fri, 10 April 2009 15:59
hi

My problem is

i am creating the partitions to my sales table to every three months...

if completes the tree months it will be created automatically for next three months....

thanks
ram

And in the process of writing this, where is your problem?
Or are you expecting we write it for you?

Regards
Michel

Re: create dynamic partitions in oracle 9 [message #397490 is a reply to message #397428] Sat, 11 April 2009 07:25 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
There is no option in 9i to create partitions automatically as they are needed.

You can pre-create them, or you can write a program that creates them for you and schedule it with DBMS_JOB

Ross Leishman
Previous Topic: Bind variable versus CURSOR_SHARING='SIMILAR'
Next Topic: TKprof shows fetching taking long time
Goto Forum:
  


Current Time: Fri Dec 02 18:43:44 CST 2016

Total time taken to generate the page: 0.37315 seconds