When SQL query is parsed then it will look first definitions of table exist in following area.
Shared Pool
Data Dictionary Cache
Data Buffer Cache
Library Cache