+ Reply to Thread
Results 1 to 7 of 7
  1. 03-04-2003 01:01 AM #1
    quester's Avatar
    quester
    quester is offline Member
    Join Date
    Mar 2002
    Posts
    200

    Does the Control File get updated when...

    When we create a User, does the control file get updated?
    Reply With Quote Reply With Quote
  2. 03-04-2003 01:06 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    better ask, what is contanined in the control file? user infos? think not
    Reply With Quote Reply With Quote
  3. 03-04-2003 01:08 AM #3
    quester's Avatar
    quester
    quester is offline Member
    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.
    Reply With Quote Reply With Quote
  4. 03-04-2003 01:13 AM #4
    feng11
    feng11 is offline Junior Member
    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
    Reply With Quote Reply With Quote
  5. 03-04-2003 01:14 AM #5
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    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"
    Reply With Quote Reply With Quote
  6. 03-04-2003 06:11 AM #6
    abdulkhadeer
    abdulkhadeer is offline Junior Member
    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
    Reply With Quote Reply With Quote
  7. 03-04-2003 06:58 AM #7
    manickvj
    manickvj is offline Junior Member
    Join Date
    Feb 2003
    Location
    India
    Posts
    3
    When a user acct is created, the control file will not get updated.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width