 ORA-28100: policy function schema RMSDEV is invalid [message #188610] |
Sun, 20 August 2006 21:51  |
pulkit_a
Messages: 50
Registered: December 2005
|
Member |
|
|
Hello,
I am trying to create a database by Export/Import one schema of existing data base.
Data base is getting created properly but i am getting the following problem when trying to access one table.
select * from store ;
ORA-28100: policy function schema RMSDEV is invalid
Rest all other tables are working fine except one table.
Can any one help me with the reason for this error and its solution.. I tried to create the new database twice but facing the same error with the same table again.
Regards
Pulkit
|
|
|
|
| Re: ORA-28100: policy function schema RMSDEV is invalid [message #188617 is a reply to message #188610] |
Mon, 21 August 2006 00:44  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| Quote: |
ORA-28100: policy function schema string is invalid
Cause: The schema was dropped after the policy associated with the function had been added to the object.
Action: Drop the policy and re-create it with a policy function owned by a valid user. Or re-create the user and the policy function under the new user.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
