title: Oracle same table name on different schema?
body: <p>Is it possible to have same table name on different schema with different data on the tables within the one database? I think rather than create multiple database (that hold same table name) i should create multiple schema instead.</p>
  
  <p>Something like:</p>
  
  <pre>
  Schema 1:
    table A, <b>table B</b>
  Schema 2:
    <b>table B</b>, table X
  
  PS: table B hold different data for each schema
  </pre>
  
  <p>And most basic question did every schema (user) hold different table set? In SQL Server and MySQL every user on same database have same table set, the difference was only on roles, how about Oracle? </p>
  
  <p>Thanks</p>