If you are a newbie to Oracle XE, this article will be definite help. Whenever xe is installed it comes default with HR schema however the shcema/user will be in locked/expired state. So to continue to create connection to hr account we first need to unlock the HR schema/user.
To unlock the HR Schema that will be used in the lab, please follow these steps.
Your database should have the HR schema enabled.
To do this, from a command line issue the command: sqlplus system
Provide the password for the system user.
In the SQLPLUS prompt write the following command Alter user HR account unlock ;
Alter user HR identified by HR;
To unlock the HR Schema that will be used in the lab, please follow these steps.
Your database should have the HR schema enabled.
To do this, from a command line issue the command: sqlplus system
Provide the password for the system user.
In the SQLPLUS prompt write the following command Alter user HR account unlock ;
Alter user HR identified by HR;
This comment has been removed by the author.
ReplyDeleteI started my blog about ADF (in Spanish) with a similar article.
ReplyDeletehttp://adfsalvaje.blogspot.com.es/2013/09/desbloquear-el-esquema-hr-en-oracle-11xe.html
Greetings from Spain
http://adfsalvaje.blogspot.com
ai092 cariumaportugalstore,xn--cariumaespaa-khb,cariuma skate shoes,fly london buty,fabletics clothing,legeromexico,flylondonjapan,cariuma skate,marcfisherbuty kv805
ReplyDelete