March 15, 2007

Changing the Current Schema

It is time consuming process for me to put the schema name in front of the objects from that schema when i am doing maintenance processes on the objects of the schema. DBA ‘s usually work with system or sys users and they have to do this alias process for not to face with ORA-00942 error (table or view does not exist). But if the connected user doesn’t have permission on the current schema object you will still get ORA-00942.

PLEASE REPLY ME
I’ve Created DEV , UCM and PORTAL schema from RCU. and Then try to install UCM ,when schema passwrd screen appear for LOGIN and Create weblogic domain , It tell me INCORRECT PASSWORD, SO , I’ve DROP these 3 schema using RCU , during DROP schema, different errors appeared , and I’ve DELETED the middleware\rcu_Home folder and Unzip the rcu.rar fresh file to the same directory
NOW
when I RUN rcu.bat and selectec CREATE SCHEMA then RCU WOUNDNT ALLOW ME TO CREATE SCHEMAS FOR PORTAL , DEV , UCM ..and also they appear in combo box to select

BUT I’ve ALREDY DROP THAT
I think it only droped not DELETED
tell me the sqlplus commands fro DELETE schema. and also tell if it is DANGEROUS to delete some schema(example DEV schema) as I’m developing portal via WEBCENTER -Jdeveloper(integrated weblogic) , Xe , RCU, UCM )

Thanks phylor I still have these days myself. I tend for
being a little of an “emotional sponge,” and when hubby is feeling miserable and negative I
actually possess a lot of trouble with not sharing his
attitude. It really is even worse on “payday,” when I see how little is left immediately after the rent is paid and I comprehend its likely to be an additional “hungry” week.

I really like your blog.. very nice colors & theme. Did youu make this website
yourself or did you hijre someone to do it for you?
Plz answer back as I’m looking to construct my own blog and would like to know where u got this from.
appreciate it