Meta table user_table question (peoplesoft)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Meta table user_table question (peoplesoft)

  1. #1
    Join Date
    Dec 2001
    Posts
    2
    I am new to Oracle (but not SQL). I am hitting a Peoplesoft database trying to list all the tables in the database. I read about the meta table User_Table but return no records. Can someone help?

    -Ken

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    To get a list of all tables you have permission on,
    SELECT * FROM ALL_TABLES;

    USER_TABLES lists the tables you own. If you logged in as somebody who didn't own anything, you would get no rows.

    If you logged in as system, you can also use DBA_TABLES to find the information you are looking for.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Posts
    2

    Smile thanks

    Thanks Jeff. Apparently I do not have the ownership or privs for xlattable. I can't see it out there. But at least now I can query the database for the tables that I do own. Thanks again.

    -Ken

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