Extraction Using DBCONNECT

[Former Member]

Hello All,

We were trying to extract data from ORACLE sysetm. Source system and bw system have oracle database.

We have successfully created source system at BW side and is able to connect to oracle source system.

But when we try to see the tables (using select database tables )system says "There is no table in database system DBEXT00001" .

What could be reason for this error message ??

Thanks

Regards

Nimesh

[edwin_harpino · Accepted solution]

hi Nimesh,

perhaps you try to access tables owned by other schema

oss 518241

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/2f0fea94-0501-0010-829c-d6b...

hope this helps.

[Former Member]

Hello AHP,

Actually we have one system on which BW development is installed.

For learning purpose we are trying to connect BW Dev oracle database as external database system.

For that we have assigned the table space BWPSABWD640 to the user , that we are using for the connection.

For current set up as explained above is it possible to extract data from BW Dev database to itself.

Regards

Nimesh