http://oracle-help.com/articles/localno-localyes-oracle/
LOCAL=NO & LOCAL=YES in Oracle