0
Résolu

Oracle Database Source

ahmad.zikri il y a 5 ans dans Studio / Sources mis à jour par Genie il y a 5 ans 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

Solution

Solution
Résolu

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

Solution
Résolu

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