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