| Oracle Internals [message #61747] |
Mon, 24 May 2004 09:02  |
Shahul Hameed.V.M
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
Respected Sir/Madam,
I would be very thankful if you could clarify two knowledge base doubts which I have and would be gald if you could throw some light on these topics.
1. Why Does create table statement use rollback segments and what does the rollback segment contain at that time.
2.What happens when we give connect internal in oracle 8i and it says connected. What actually it connects to when my instance is down.
Thanking You for the same.
Yours Sincerely,
Shahul Hameed.
|
|
|
|
| Re: Oracle Internals [message #61776 is a reply to message #61747] |
Wed, 26 May 2004 12:33  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
>> 1. Why Does create table statement use rollback segments and what does the rollback segment contain at that time.
Oracle uses a rollback segment when you issue the CREATE TABLE stmt because your create table stmt causes oracle to insert data (table, column, space info) into the data dictionary. So the rollback segment contains before image information about the data dictionary base tables.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
