SQL & PL/SQL

Hi,

I heard that schema contains different name spaces. how to find those different namespaces in schema?

I checked with this but it is throwing "table or view doesn't exist".

select namespace from v$librarycache;


Thanks
Praveen