Issue with XDB user
Hello,
Recently i tried to install the XDB components into an existing oracle database. The installation using DBCA failed.
while I was investigating the failures, my DBA decided to drop the xdb user without first backing it up.
My database is still up and running, however i do need to get the xdb components installed. I have seen several references to catnoqm.sql, but i do not want tog go this route as i know it will delete objects that have been created since the failed install. not an option.
I thought about trying to use the reload (xdbrelod.sql) function. but i am looking for some advice.
Recently i tried to install the XDB components into an existing oracle database. The installation using DBCA failed.
while I was investigating the failures, my DBA decided to drop the xdb user without first backing it up.
My database is still up and running, however i do need to get the xdb components installed. I have seen several references to catnoqm.sql, but i do not want tog go this route as i know it will delete objects that have been created since the failed install. not an option.
I thought about trying to use the reload (xdbrelod.sql) function. but i am looking for some advice.
0