Oracle table in SAP Schema

[Former Member]

Hi Gurus,

Can we create a oracle table in SAP schema directly from back-end and update it by taking snapshot from other oracle system.

I know its not a recommended solution and DB link / DBCon would be better solution but the problem is other oracle system is not ready to give us access/userID to connect to it using DBlink.

Can we access the table create above using native SQL statement or can we create a synonym to a ztable created using se11.

Thanks in advanced.

Sumit

[Former Member]

It is possible to create a table as a copy from a table in a different database, using native sql in sqlplus.

A precondition is a working database link to the other database.

If they are not ready to give you access, then, well, no way here either.

regards

[former_member204746]

also, in SAP, make sure that table buffering for this table is set to OFF.

Also make sure that this job runs from your SAP server, you SAP/Oracle license forbids you to fetch SAP data to another DB... but not the other way around.

[Former Member]

Thanks Guys,

Another question , does SAP license allows creation of table/view at oracle level directly.

If we create a table will this violate the license agreement SAP/Oracle.

Also I understands SAP will not support the the table directly created in the database , so if we create the table in DB will we still get db support apart from the table created in SAP.

Thanks,

Sumit

[former_member204746]

you can create view at DB level... but it does not make sense if it is not in SAP's data dictionary...

you must use Oracle SAP Schema SAPxxx where xxx is, R3, SR3 or your SID..