Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    44

    Unanswered: How to determine if the schema is active in db?

    Hi All,

    We are smalll company, so we have our stucture about db, a schema in the db seems a small database, we have differecnt project on diffrent schema, usually as a project is finished, that schema would be closed and moved out from the db, but as the time being, some schemaes are exiting there forever, so we want to do a clean job, but before this we need to make suer if the schema is active or not, but some schema have so many tables, couldn't take a look at table by table, so I'm wondering if someone know any methods to detemint if a schema active or not currently?

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Lock the suspect account's and wait until someone shouts! -- If no one complains, export and drop the schema.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    May 2004
    Posts
    44
    Thanks, I think it might be the only I can do now.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    AUDIT SESSION will allow you to track which schemas have logged into the DB.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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