Oracl Internal Arch. (contd)
DB Block : This is in some integral multiples of OS block size. Usually both are 2K.
- SYSTEM tablespace : contains tables, indexes, clusters & views.
- view USER_TABLES : gives information about tables in your DB.
ALL_TABLES : gives all tables that you can access.
- Oracle table/column names are not case sensitive