not able to access data from registered table

lalita

Hi,

I have registered a table in dql as:

USER_TYPE_ID   INTEGER ,
USER_TYPE_NAME CHAR(2000),
ATTRIBUTE1     CHAR(1000),
ATTRIBUTE2     CHAR(1000)

)
with key(USER_TYPE_ID)
synonym for 'DEVREP.USER_TYPE'

where user_type_s is the name of synonym ,DEVREP is the owner name

and USER_TYPE is the actual table in the RDBMS.

it is registered successfully.

then i update the permissions using:

UPDATE DM_REGISTERED OBJECT
SET OWNER_TABLE_PERMIT=15,
SET GROUP_TABLE_PERMIT=15,
SET WORLD_TABLE_PERMIT=15
WHERE R_OBJECT_ID = '1900XXXXXX'

now when i execute a query select * from dm_dbo.user_type_s

it is giving error

Dql--Enter Query:
select * from dm_dbo.user_type_s
Show the SQL

Error occured during query execution :[DM_QUERY2_E_TABLE_NOT_FOUND]error: "The database table or view was not found in the database. Error from the database was: 'ORA-00942: table or view does not exist

some one plz correct me where i am wrong.

Find more posts tagged with

Comments

DCTM_Guru

Delete existing registered object and try using this register dql (and repeat your other steps):

register table dbo.user_type_s

lalita

hi...Johnny,

I did all the thing as mentioned by u but again when i m executing the following query

select * from dbo.user_type_s

I am getting the same error

DCTM_Guru

Try:

select * from dm_dbo.user_type_s

on the existing registered object

lalita

it also dnt work.

DCTM_Guru

I just re-read your original post. If the table name is actually USER_TYPE, then your register and select statement should NOT contain _S. The _s and _r in the repository are tables that map to object types. This is entirely different than registered tables.

lalita

Hi...

Actually my original table name is user_type but i have created a synonym for this table named user_type_s.so i am trying to fetch data through synonym rather than the actual table.can't we name a synonym following by _r or _s,that's wat u want to tell.

Francois Dauberlieu

Instead of registering your synonim, did you try to register the table directly ?

lalita

Hi..

thanks for the reply.

But If i ll directly register table then how i will b able to use synonym..as dql for registering table directly will not involve the synonym name.

can u plz illustrate wid example...for the scenario as mentioned by me in the original post.

DCTM_Guru

Why do you need to use synonym? Either register the table name as user_type_s or query using user_type.