Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2012
    Location
    Gibraltar
    Posts
    4

    Unanswered: earch the history for the all tables that are created by a user

    i'm new in oracle/sql world., and i know how to find a answer by myself searching., and searching again .. but for my new issue i d'ont find a good answer, so i just want to find the history of manipulation the database by filtering the user who created the last tables, what tables are, when he created it etc ..

    I'm using oracle XE and the client is toad.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    query USER_OBJECTS
    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.

  3. #3
    Join Date
    Mar 2012
    Location
    Gibraltar
    Posts
    4
    your answer is not good., for example if we try

    select table_name from sys.dba_tables where owner='SYSTEM'

    but i want to search in these tables for a explicit date .. let say 01/02/2011., i mean i want to know the tables that was created or the tables that have modificacions from 01/02/2011 to 01/09/2011 by 'SYSTEM' user

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >your answer is not good., i try
    I disagree.

    >select table_name from sys.dba_tables where owner='SYSTEM'
    you did not query the object I specified.
    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.

  5. #5
    Join Date
    Mar 2012
    Location
    Gibraltar
    Posts
    4
    Quote Originally Posted by anacedent View Post
    >your answer is not good., i try
    I disagree.
    but if you're not giving up any solution and and you are the non-conforming!?!

    >select table_name from sys.dba_tables where owner='SYSTEM'
    you did not query the object I specified.
    this is the reason for why i asking in this forum how can i call in a query what i want.

    thank you

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >but if you're not giving up any solution and and you are the non-conforming!?

    If you are ever dissatisfied with the tone, tenor, completeness, correctness, or timeliness of any response,
    please submit your request for a prompt & full refund to /dev/null
    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.

  7. #7
    Join Date
    Mar 2007
    Posts
    623
    Are you really unable to spot the difference?
    > from sys.dba_tables (your query)
    > query USER_OBJECTS (anacedent's suggestion)
    You may list columns of the second system view e.g. using DESC sqlplus command. Or, simply consult Oracle Reference book, which is available with other Oracle documentation e.g. online on http://tahiti.oracle.com

  8. #8
    Join Date
    Mar 2012
    Location
    Gibraltar
    Posts
    4
    USER_OBJECTS

    well, i try with my query to put user_objects and is not working

    select table_name from user_objects_tables where owner='SYSTEM'

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >well, i try with my query to put user_objects and is not working
    when you do it wrong, the results will not be as desired.

    >select table_name from user_objects_tables where owner='SYSTEM'

    what is "user_objects_tables"?

    USER_OBJECTS only presents objects that are owned by current USER; who ever that may be.
    ALL_OBJECTS presents objects that current USER can SELECT from.
    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.

  10. #10
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    and dba/all/user_objects shows the date of last modification, creation, type of object and a bunch of other good stuff.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Tags for this Thread

Posting Permissions

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