Hello, I was looking for how to change this syntax from sql server to oracle and I still do not understand the structure that oracle has in its bd.
The sql server syntax:
USE [BD] GO /****** Object: User [pepe] Script Date: 06/05/2017 10:17:14 ******/ CREATE USER [pepe] FOR LOGIN [pepe] WITH DEFAULT_SCHEMA=[dbo]
and I understand that in oracle it would be:
USE BD create user pepe identified by pepe; GRANT CREATE SESSION TO pepe;
And I do not know how to continue migrating the part of the 'WITH DEFAULT_SCHEMA = [dbo]'. I hope you can help me please.