-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|