ORA-01779: non key-preserved tables 2

[KenCunningham]

Hi folks, and a Happy New Year to all,

I'm having a problem in updating the PROFILE value in DBA_TABLES because it keeps throwing a:

ORA-01779: cannot modify a column which maps to a non key-preserved table

error. I've Googled and understand that this relates to non-updateable views. However, can anyone explain how to identify the underlying tables which do need to be altered to effect the change required?

TIA.

I want to be good, is that not enough?

 

[Dagon]

select * from SYS.DBA_views where view_name = 'DBA_TABLES'

should tell you. But what you're trying to do sounds highly questionable, to say the least. I don't think Oracle would recommend changing any SYS tables directly.

 

[KenCunningham]

Thanks Dagon, in the original question I typed DBA_TABLES, meaning DBA_USERS. Your query doesn't seem to give any information about underlying tables for DBA_USERS. or for DBA_TABLES if I use that, for that matter.

I should stress that this is in a test environment and is designed for checking out some of the password expiry etc features of Oracle.

I want to be good, is that not enough?

 

[jaxtell]

ALTER USER username PROFILE profile_name

 

[KenCunningham]

As simple as that! Many thanks. A star for you, and one for Dagon too, given my initial mash-up.

I want to be good, is that not enough?