Oracle: View tables owned by a specific user

Source: Internet
Author: User

1. Under normal users
1.1 view the user_tables View
Select table_name from user_tables;
TABLE_NAME
------------------------------
PROJECT_MANAGE
SALGRADE
BONUS
EMP
DEPT
//
1.2 view the all_tables view [available to sysdba users or common users]
Select table_name from all_tables where owner = 'Scott ';
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
PROJECT_MANAGE
//
2. sysdba permission
View dba_tables View
Select table_name from dba_tables where owner = 'Scott ';
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
PROJECT_MANAGE
//
Note: The all_objects view can also view all tables of a specified user,
However, this view contains not only tables, but also objects owned by this user.
For example, view, primary key, foreign key, procedure, function, sequence ,...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.