if you use the same command line to execute the command, your PWD is sh_pass. You can connect to sys or system and change pwd if you do not remember. you need to use Alter user sh identified by to change PWD.
Hi Manish, hope you're well. I tried the same with my already existing 11g xe database in my laptop. I could see the SH user is created, however no objects are created. I rechecked using select * from dba_users where owner='SH'; ---0 results fetched. Is there any issues? Happy to hear from you soon. Have a great day!
When you open the script, where are you opening the script in? Did you open in SQL Developer, in SQL, in SQLPlus? There are detail you are leaving out and they may be minor details, but it prevents us from following you.
Great Thank you so much , I was struggling all the day to find a solution, But now when I tried to make same steps with HR and OE it gives me error " Unauthorized"
Hi Manish Sharma, I successfully created User SH. When I expand the Tables section, no tables have been found. I don't understand what went wrong? Could you help?
Hi i am working as a plsql developer. But i have questions for you could you tell me why we use array in plsql if we have cursor in plsql . I think both are work same . Could explain me .
Hello While installing Oracle 18c I am getting an error in the last step: which shows Oracle services for Microsoft transactions server failed . PLZ help me out in solving this
bro i have installed and i opened and i have logged successfully to sh schema and later i tried to login it is showing username and password denied but i never changed the details from sh and sh_pass now what i have to do?
first check if the pluggable database which is holding your SH schema is open or not (refer this ru-vid.comLfWkhyNszpU) second switch to the pluggable database which has your schema and then save it open state (refer this ru-vid.combeYcobrCKG0)