Hello and welcome.
In this video I'll be showing you how you can unlock the call hey are scheme by default.
Once you've installed the recall database it also includes some sample schemer's.
They will be blocked.
So you need to unlock it to get access to the objects within that scheme.
What is a scanner scanner is a fancy name for a use that I can't see or you can look at to see him schema
like a set of database objects.
For example the tables that are owned by the user.
So this scheme really is a collection of objects owned by a user account in Oracle users and schemas
are essentially the same thing.
You can consider that a user is the account that you use to connect to a database and schema is the
set of objects which include things like tables use and so on.
That belongs to that account.
So this huge schema that we are going to unlock in this video is is some poor scheme that is provided
when you install or a call database to unlock the schema.
You need to use a command line if you are used in a Mac.
You can use your terminal if you own a Windows you use a common prompt.
I'll be lost weight and with a Windows based computer.
So I'll go to my program far click on access series and then click on the Command Prompt and it will
give me the command prompt interface.
So once you've got the command prompt you need to type mean s q L plots all in one word press enter
and then for the user name enter system
press enter a password will be the password that you created when you installed that or a call database.
So a time that password in
hand if you've typed it incorrectly just press enter and you should have connected to.
Or a cool eleven G express release production so once you get that it means your password is correct
and you have connected to the database to unlock the schema you need to type in the word alter
space user space.
Remember that's going to be a char and then type in count
space type in the word unlock
space.
Type in the word identified.
Okay.
Space typing by and then the password you want it to have.
So I'm going to make typing.
Hey char as a password and they end up with a semicolon the semicolon is important.
It tells esky tells the system that you have finished your statement and then you press enter.
So you should get a message to says you are altered which means you have successfully unlocked here.
Ah schema.
So just type in exit to exit the rescue plots Plus it tells you disconnected from Oracle database.
Now will want to do type in Eskimo plus again and try and see if we can access a database using be here
char scheme that we've just unlocked.
So type in here char.
The is in a press enter a password type in here.
Try again in the one case press enter and you should get a connected to Oracle database production so
once you've connected it means that you have successfully unlocked the hey char count.
So once you've done you can just type in exit to exit the Eskew bloss group so that's that you have
successfully unlocked the.
Are scheme.
Thanks for watching.
Bye for now.