When we create a User, does the control file get updated?
Printable View
When we create a User, does the control file get updated?
better ask, what is contanined in the control file? user infos? think not
thx pando. i thought so, just wanted to reconfirm.Quote:
Originally posted by pando
better ask, what is contanined in the control file? user infos? think not
Controlfile does not get updated when you create a user account.
It mainly contains :
1) database name and instance name
2) time stamp of db creation
3) name and locations of datafiles, online redo logs
4) location of backups if using RMAN
5) current log sequence
6) checkpoint information
Pando : Stop celebguy_dv from posting message.....hes crazy
quester
When ever the user or dba make changes to the database the control will get update . what ever it may be ..
abdulkhadeer
When a user acct is created, the control file will not get updated.