You must create schemas for Oracle databases manually.
Use schematool to view and create relational database management system (RDBMS) schemas.
schematool
See Apache Hive documentation for the detailed steps.