1. Community
  2. Studio
  3. Sources
  4. Вопросы
0
Отвечен

Oracle Database Source

ahmad zikri 7 лет назад в Studio / Sources • обновлен anonymous 7 лет назад • 1

Hi. Why when I create Oracle database source the database choices are limited to HR, SCOTT, OE, PM, SH and IX

There should be user that i create as database. For example, there be include 'SPBO2' as if in normal oracle query it will be SELECT * FROM SPBO2.TABLENAME

Thank you

database

Ответ

Ответ
Отвечен
anonymous 7 лет назад

Hi,


The databases are limited to the databases that the that you have logged in with has access to, using the following command


SELECT DISTINCT(OWNER) AS DATABASE_NAME FROM DBA_SEGMENTS WHERE OWNER IN (SELECT USERNAME FROM DBA_USERS WHERE DEFAULT_TABLESPACE NOT IN ('SYSTEM','SYSAUX'))


Thanks

Ответ
Отвечен
anonymous 7 лет назад

Hi,


The databases are limited to the databases that the that you have logged in with has access to, using the following command


SELECT DISTINCT(OWNER) AS DATABASE_NAME FROM DBA_SEGMENTS WHERE OWNER IN (SELECT USERNAME FROM DBA_USERS WHERE DEFAULT_TABLESPACE NOT IN ('SYSTEM','SYSAUX'))


Thanks

Сервис поддержки клиентов работает на платформе UserEcho