" /> Oracle Instance or Schemas - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Oracle Instance or Schemas  (Read 2762 times)

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Oracle Instance or Schemas
« on: April 29, 2009, 04:50:32 PM »
Advertisement
Hi guys,
For Oracle, each component of Genesys needs an Instance or a Schema? Meaning the DB for ETL, ConfigServer, ODS, etc etc.
Thanks
Logged

Offline catanirex

  • Sr. Member
  • ****
  • Posts: 272
  • Karma: 11
Re: Oracle Instance or Schemas
« Reply #1 on: April 29, 2009, 06:13:38 PM »
A schema :-)

Microsoft SQL vs Oracle

Server = instance
database=schema

Which means that you have one user/pw for every schema in Oracle.

In MSQL you can have the same user/pw for several dbs.

Hope this helps!
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Oracle Instance or Schemas
« Reply #2 on: April 29, 2009, 06:17:03 PM »
;D Yeah, it was! I had forgot Oracle at all...been years I don't work with it.
Thanks!
Logged
Pages: [1]   Go Up
« previous next »