Home » RDBMS Server » Performance Tuning » New User Help Me Out (merged 2) (Oracle 11gR2, Linux)
New User Help Me Out (merged 2) [message #548127] Tue, 20 March 2012 08:11 Go to next message
shehzaadkareem
Messages: 3
Registered: March 2012
Location: india
Junior Member
Friends i am a new user on this forum .

Sorry i couldnt post in appropriate Topic as i couldnt judge to post my question in which topic so posting here .Moderators Sorry for this.


My Questions is:


I want to insert 10mb of data into a database named db1

I want the 10mb arrangement of data in such a way that the first 3 mb should go in tablespace named ts1

Next 4mb should go in tablespace named ts2.

remaining 3mb should go in tablespace named ts3.

Can anyone help me out how can i make it happen.The motto is how can a user allocate specific amount of data to a particular tablespace and remaining to other tablespace.



Thanks In Advance Smile
Re: New User Help Me Out (merged 2) [message #548130 is a reply to message #548127] Tue, 20 March 2012 08:24 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Any given table can only have one tablespace.
So unless you want to insert each block of data into a different table this simply isn't possible.
Why are you trying to do this?
Re: New User Help Me Out (merged 2) [message #548144 is a reply to message #548130] Tue, 20 March 2012 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or you can partition your table in a way that 1/3 of rows come into each partition.

Regards
Michel
Re: New User Help Me Out (merged 2) [message #548199 is a reply to message #548144] Tue, 20 March 2012 13:30 Go to previous messageGo to next message
shehzaadkareem
Messages: 3
Registered: March 2012
Location: india
Junior Member
Cookiemonster:

Very well said that one can assign a table only to a tablespace once at a time.

But is that possible that i can exactly divide the data as per my memory requirements

and any query which automatically assign a table with other tablespace once the 2mb memory gets filled

Is there any automation query or script by which a table after assigning 2mb of data should be assigned to second tablespace and fill it with 5 mb

likely after completion of 5mb the table should automatically switch to tablespace 3.


Michel Cadot:

Thanks for the reply brother !

Can u help me with my above specified automation task ?
Re: New User Help Me Out (merged 2) [message #548201 is a reply to message #548199] Tue, 20 March 2012 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
the requirements make *NO* sense.
why are you obsessed with desiring data go into different tablespaces?
what problem are you really trying to solve?
Re: New User Help Me Out (merged 2) [message #548202 is a reply to message #548199] Tue, 20 March 2012 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
in 11.2 you can choose system partitioning and choose the partition where you want to insert your data.
I don't see why you want to do that maybe if you explain what is your final goall we can tell you how to achieve this.

Regards
Michel

[Updated on: Tue, 20 March 2012 13:42]

Report message to a moderator

Re: New User Help Me Out (merged 2) [message #548209 is a reply to message #548202] Tue, 20 March 2012 15:45 Go to previous message
shehzaadkareem
Messages: 3
Registered: March 2012
Location: india
Junior Member
Thanks alot guys thou i dont have any speicifc goal but i just got a doubt whether it can happen or not

yes Michel using partitioning we can accompalish


Thanks you Once again guyx Smile
Previous Topic: Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2)
Next Topic: TABLESPACE EXTENT
Goto Forum:
  


Current Time: Thu Mar 28 03:44:59 CDT 2024