Does the Control File get updated when...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Does the Control File get updated when...

  1. #1
    Join Date
    Mar 2002
    Posts
    200

    Does the Control File get updated when...

    When we create a User, does the control file get updated?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    better ask, what is contanined in the control file? user infos? think not

  3. #3
    Join Date
    Mar 2002
    Posts
    200
    Originally posted by pando
    better ask, what is contanined in the control file? user infos? think not
    thx pando. i thought so, just wanted to reconfirm.

  4. #4
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49
    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
    Regards
    CF

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Pando : Stop celebguy_dv from posting message.....hes crazy
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Jan 2003
    Location
    india(bangalore )
    Posts
    14

    control file

    quester


    When ever the user or dba make changes to the database the control will get update . what ever it may be ..

    abdulkhadeer
    abdulkhadeer

  7. #7
    Join Date
    Feb 2003
    Location
    India
    Posts
    3
    When a user acct is created, the control file will not get updated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width