inserting the data in the deleted part of a table [message #362141] |
Mon, 01 December 2008 03:23  |
jyothsna1612
Messages: 68 Registered: June 2008
|
Member |
|
|
Hi,
I have a table and inserted from 1 to 50 records...
And now i deleted 20 - 30 means 10 records...
Now i want to insert the 10 records into the deleted portion i.e; between 20-30 portion
How would that be possible...
Please let me know if i'm not clear....
Thanks....
|
|
|
|
|
|
Re: inserting the data in the deleted part of a table [message #362270 is a reply to message #362141] |
Mon, 01 December 2008 11:26  |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
I am not sure, whether you are aware about the way Oracle stores its data. It is described in the Concepts book, which is part of the documentation, available e.g. online on http://tahiti.oracle.com/.
It is described Chapter 2 "Data Blocks, Extents, and Segments" in Part II "Oracle Database Architecture". Maybe you could precise your question after you read it (and realize that internal data storage is Oracle job not influenceable so precisely as you think).
|
|
|