Table Does Not Exist in Datasource

Hello,
I'm doing a refresh of data using SQL. OW does not recognize that the
newly created tables exist. I can do anything I want with the tables and
the data in SQL. If I remove the table, I can copy the table from another
datasource to this new datasource successfully using OW, so my datasource
settings and OCM mappings are correct. Does anyone know how to get OW to
see these tables after a SQL copy?

Thanks,
Thomas
OneWorld XE Update 7 SP18.1
Sun, Oracle 8.1.6

Dear Thomas,

In the OMW of the target environment, Do a ‘Get’ Spec from the environment that you designed the table & then, generate the Table & check-in. Then, try to copy the data to that table.

Try it out & it should work!

Rgds
Nailesh

Thomas,

try to log into the environment that has the table in question checked-in to it´s pathcode (OL F9861) when doing the copy (are you using R98403?). Make sure that the table specs are on the WS that executes the copy.

Thanks, Gerd

You may want to make sure that your oracle schema owner is correct and the oracle grants are correct for the table. Usually the user role 'public' is granted select,insert,update,delete, alter on the table.