| SCN NUMBER & Chained Rows [message #50832] |
Wed, 10 April 2002 01:00  |
Prasad.V.R
Messages: 2
Registered: April 2002
|
Junior Member |
|
|
Hai I have Couple of Questions
1) I Open the Database with OPEN RESETLOGS, Is it Resets SCN(I think no),Which view I need to refer to
check the present SCN, is checkpoint_change# in V$database can be treated as SCN Number.
2) If a Remove Chained Rows from a table & insert new rows using Exception table, Whether I need to rebuild
indexes once again
Thanx
Prasad
|
|
|
|
| Re: SCN NUMBER & Chained Rows [message #50841 is a reply to message #50832] |
Wed, 10 April 2002 16:35  |
Kishore
Messages: 45
Registered: September 2000
|
Member |
|
|
Hi,
1. You are correct. RESETLOGS option will not change the SCN. It will discard all the redo information and adjusts the LOG SEQUENCE NUMBER to 1 and updates the control file accordingly.
2. Yes, you need to rebuild the indexes. Because you are deleting the row set and insert them back again.
I hope this helps,
Kishore
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
