Multiple Schemas on an Oracle Owner

Asked

Viewed 714 times

1

Hello,

I have a question for a while and can’t find a definitive answer: I may have several schemas on an oracle Owner?

Ex.:

Owner: Renan

Schemas:

  1. Indicators

  2. Alert

  3. Etc.

Tables:

  1. Renan.Indicadores.tb_rend_acum_teste
  2. Renan.Alerta.tb_flight
  3. Renan.etc.test

In SQL SERVER it works like this and I wonder if I can do the same thing in oracle.

Thank you.

oracle

2 answers

2


  • I will have to create several users then. Thank you.

0

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

Browser other questions tagged oracle

You are not signed in. Login or sign up in order to post.