Register table with ID

hi experts,

how can i register a table with the following colmns?

ID                                        NOT NULL NUMBER(10)
CODE                                               VARCHAR2(12)
TYPEID                                             NUMBER(10)
SHORTNAMESTRID                                     NUMBER(10)
NAMESTRID                                          NUMBER(10)
ADDRESSSTRID                                       NUMBER(10)
PHONE                                              VARCHAR2(40)
FAX                                                VARCHAR2(40)
EMAIL                                              VARCHAR2(40)
TELEX                                              VARCHAR2(40)
SWIFTCODE                                          VARCHAR2(11)

Find more posts tagged with

Comments

lastnitescurry

See Register in DQL reference manual

* "Registers a table from the underlying RDBMS with the repository

after registering it, it is a very good idea to set ACL to dm_acl_systemmethod and grant the correct table permissions.....

Incorect permissions on registered tables are one of the first failure points when moving from DEV

Swapna_Patro

First Register the Table

Then Set permission

update dm_registered object
set owner_table_permit = 15,
set group_table_permit = 15,
set world_table_permit = 15
where object_name ='<table_name>'

While Registering you can give any column name. but it is a good practice to porvide all the exact column names and datatype.

Thanks,

Swapna