Multiple Schemas in an Oracle Owner

Navigation
1

Hello,

I have a question at a time and I do not find a definitive answer: Can I have multiple schemas in an oracle owner?

Ex:

Owner: Renan

Schemas:

  • Indicators

  • Alert

  • Etc

    • Tables:

  • renan.Indicadores.tb_rend_acum_teste
  • renan.Alerta.tb_voo
  • renan.etc.teste

    • In SQL SERVER it works like this and I would like to know if I can do the same thing on oracle.

    Thank you.

        
    asked by anonymous 10.03.2015 / 19:41

    2 answers

    2

    ORACLE works differently. When creating a user a schema is already associated with it with the same name.

    Here's an explanation of this: [ link

        
    10.03.2015 / 20:39
    0

    No. Each user has their own schema that are all their objects in the database, from tables, to views, synonyms and so on.

        
    18.03.2015 / 16:33
    Player with onGoingNotification I can not get the jQuery Vegas plugin to work