1
00:00:00,510 --> 00:00:01,670
Hello and welcome.

2
00:00:01,680 --> 00:00:10,650
In this video I'll be showing you how you can unlock the call hey are scheme by default.

3
00:00:10,680 --> 00:00:17,870
Once you've installed the recall database it also includes some sample schemer's.

4
00:00:17,940 --> 00:00:19,310
They will be blocked.

5
00:00:19,410 --> 00:00:25,900
So you need to unlock it to get access to the objects within that scheme.

6
00:00:25,920 --> 00:00:37,940
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

7
00:00:38,180 --> 00:00:43,100
like a set of database objects.

8
00:00:43,320 --> 00:00:48,910
For example the tables that are owned by the user.

9
00:00:49,290 --> 00:01:00,240
So this scheme really is a collection of objects owned by a user account in Oracle users and schemas

10
00:01:00,360 --> 00:01:03,640
are essentially the same thing.

11
00:01:03,690 --> 00:01:15,270
You can consider that a user is the account that you use to connect to a database and schema is the

12
00:01:15,270 --> 00:01:21,990
set of objects which include things like tables use and so on.

13
00:01:22,140 --> 00:01:26,390
That belongs to that account.

14
00:01:26,820 --> 00:01:36,930
So this huge schema that we are going to unlock in this video is is some poor scheme that is provided

15
00:01:37,290 --> 00:01:42,810
when you install or a call database to unlock the schema.

16
00:01:43,080 --> 00:01:46,500
You need to use a command line if you are used in a Mac.

17
00:01:46,500 --> 00:01:50,790
You can use your terminal if you own a Windows you use a common prompt.

18
00:01:50,850 --> 00:01:53,960
I'll be lost weight and with a Windows based computer.

19
00:01:54,270 --> 00:02:01,980
So I'll go to my program far click on access series and then click on the Command Prompt and it will

20
00:02:01,980 --> 00:02:05,040
give me the command prompt interface.

21
00:02:05,190 --> 00:02:18,000
So once you've got the command prompt you need to type mean s q L plots all in one word press enter

22
00:02:19,140 --> 00:02:22,650
and then for the user name enter system

23
00:02:25,320 --> 00:02:35,510
press enter a password will be the password that you created when you installed that or a call database.

24
00:02:35,520 --> 00:02:37,020
So a time that password in

25
00:02:40,620 --> 00:02:46,780
hand if you've typed it incorrectly just press enter and you should have connected to.

26
00:02:46,790 --> 00:02:54,690
Or a cool eleven G express release production so once you get that it means your password is correct

27
00:02:55,140 --> 00:03:03,120
and you have connected to the database to unlock the schema you need to type in the word alter

28
00:03:05,610 --> 00:03:11,530
space user space.

29
00:03:11,570 --> 00:03:15,840
Remember that's going to be a char and then type in count

30
00:03:19,230 --> 00:03:21,950
space type in the word unlock

31
00:03:25,390 --> 00:03:26,460
space.

32
00:03:26,700 --> 00:03:32,350
Type in the word identified.

33
00:03:34,540 --> 00:03:35,510
Okay.

34
00:03:35,540 --> 00:03:41,360
Space typing by and then the password you want it to have.

35
00:03:41,430 --> 00:03:43,210
So I'm going to make typing.

36
00:03:43,230 --> 00:03:48,920
Hey char as a password and they end up with a semicolon the semicolon is important.

37
00:03:49,110 --> 00:03:56,630
It tells esky tells the system that you have finished your statement and then you press enter.

38
00:03:56,940 --> 00:04:04,380
So you should get a message to says you are altered which means you have successfully unlocked here.

39
00:04:04,440 --> 00:04:05,760
Ah schema.

40
00:04:05,940 --> 00:04:15,110
So just type in exit to exit the rescue plots Plus it tells you disconnected from Oracle database.

41
00:04:15,150 --> 00:04:25,200
Now will want to do type in Eskimo plus again and try and see if we can access a database using be here

42
00:04:25,200 --> 00:04:27,810
char scheme that we've just unlocked.

43
00:04:28,070 --> 00:04:29,940
So type in here char.

44
00:04:30,120 --> 00:04:34,290
The is in a press enter a password type in here.

45
00:04:34,290 --> 00:04:43,260
Try again in the one case press enter and you should get a connected to Oracle database production so

46
00:04:43,260 --> 00:04:49,740
once you've connected it means that you have successfully unlocked the hey char count.

47
00:04:50,010 --> 00:04:57,270
So once you've done you can just type in exit to exit the Eskew bloss group so that's that you have

48
00:04:57,270 --> 00:04:59,910
successfully unlocked the.

49
00:05:00,450 --> 00:05:01,520
Are scheme.

50
00:05:01,710 --> 00:05:02,970
Thanks for watching.

51
00:05:02,970 --> 00:05:04,010
Bye for now.