| Storing a table date in a particular datafile [message #142569] |
Sun, 16 October 2005 01:15  |
jazzmy
Messages: 4
Registered: September 2005
|
Junior Member |
|
|
Hello
Is there anyway that i can tell oracle that to put the data of a particular table in a tablespace to a specific datafile. so that i can store data of different tables in a tablespace saperately in differet specific datafiles.
thanks
|
|
|
|
| Re: Storing a table date in a particular datafile [message #142581 is a reply to message #142569] |
Sun, 16 October 2005 04:05  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
I think you can but you have to preallocate extents to a table mean to say the table should not grow automatically .
SQL> ALTER TABLE emp ALLOCATE EXTENT ( DATAFILE 'data1.dbf' );
but this datafile should belong to the same tablespace in which the table was created.
regards,
tarun
|
|
|
|
| Re: Storing a table date in a particular datafile [message #142652 is a reply to message #142569] |
Mon, 17 October 2005 02:20 |
Eric Langager
Messages: 38
Registered: April 2004
Location: Beijing, China
|
Member |
|
|
|
Generally, if a tablespace has more than one datafile, Oracle decides for you in which particular datafile to store a given body of data. The assumption is that the user controls allocation of data to the logical object (tablespace), and Oracle manages allocation of data to the specific physical object (datafile).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
