-
Discrepancies: USER_TABLES and USER_SEGMENTS
In a schema HR (deployed when i installed Oracle 10g rel. 2), i run this statement:
SQL> select segment_name from user_segments where segment_type='TABLE';
and the result is:
SEGMENT_NAME
------------------------------------------------------------------------
REGIONS
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY
Selezionate 6 righe.
If I run this statement:
SQL> select table_name from user_tables;
instead, the result is:
TABLE_NAME
------------------------------
REGIONS
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY
COUNTRIES
Selezionate 7 righe.
Why i don't see COUNTRIES table in USER_SEGMENTS ?
Regards,
Dave
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
|