• "In my understanding, a schema in Oracle is like a database in SQL Server."

    I think a database in SQL Server would be more like a tablespace in Oracle. FWIW.