1 00:00:01,440 --> 00:00:02,970 Hello and welcome. 2 00:00:03,150 --> 00:00:10,170 We users log in to our core application l'express or apex. 3 00:00:10,350 --> 00:00:18,830 They are actually logging in to a shared work area which is called the work space. 4 00:00:19,020 --> 00:00:30,180 So a work space basically is a virtual private database that allows multiple users to work within the 5 00:00:30,180 --> 00:00:41,160 same or a core application express installation while keeping up objects their data and applications 6 00:00:41,430 --> 00:00:42,180 private 7 00:00:44,550 --> 00:00:53,070 Also each workspace has a unique numeric páidí and name. 8 00:00:54,310 --> 00:01:06,690 So if any changes are required to a workspace the change has to be submitted to by the workspace administrator 9 00:01:07,100 --> 00:01:08,640 is submitted to the. 10 00:01:08,640 --> 00:01:09,790 Or a call. 11 00:01:09,990 --> 00:01:20,430 He picks administrator so only the Oracle application express administrator can approve changes relating 12 00:01:20,430 --> 00:01:31,860 to request for the workspace as a peg's administrator or a core application express happiness straight 13 00:01:31,860 --> 00:01:39,350 up one of your functions will be to prove to provision a workspace by proficiency. 14 00:01:39,360 --> 00:01:49,260 I mean creating So you tasks will provision in several work spaces usually some of this processes can 15 00:01:49,260 --> 00:01:56,840 be automated with a script so as an administrator you can use this group to automate the process. 16 00:01:56,850 --> 00:02:04,070 That will probably generate a workspace in a Around time environment. 17 00:02:04,080 --> 00:02:15,690 However in this course we are going to manually provision or create a work space so the workspace we 18 00:02:15,690 --> 00:02:19,690 are going to create is going to be a month long process. 19 00:02:19,720 --> 00:02:28,440 How are we going to create it in a full complete development environment to create a workspace. 20 00:02:28,440 --> 00:02:32,160 You have to log in to the application express. 21 00:02:32,160 --> 00:02:40,980 I have already been with the user name system and the password they used was the password I set up when 22 00:02:40,980 --> 00:02:43,680 the database was created. 23 00:02:43,770 --> 00:02:50,150 So this is the interface you will see in order to create the workspace. 24 00:02:50,150 --> 00:02:58,740 Notice secret workspace icon there before you can create a workspace. 25 00:02:58,770 --> 00:03:01,710 There are several things you need to get started. 26 00:03:01,710 --> 00:03:03,550 They are listed here. 27 00:03:03,570 --> 00:03:10,790 It tells you here to get started you need to have a database username which is the name of the database 28 00:03:10,810 --> 00:03:19,560 user that to be created in need an application the Express user name which is your log in name for the 29 00:03:19,560 --> 00:03:22,170 application express workspace. 30 00:03:22,170 --> 00:03:24,540 Note that the log in name. 31 00:03:24,540 --> 00:03:32,220 To log in to the application express workspace is different from the outroar application Express so 32 00:03:32,220 --> 00:03:37,450 you log into the console or here use system. 33 00:03:37,680 --> 00:03:47,190 The password you set of durene database admin database installation as zoomin that you are the database 34 00:03:47,310 --> 00:03:48,620 administrator. 35 00:03:48,920 --> 00:03:58,390 Okay then you need to have a password for both the database user and the application express use that 36 00:03:58,500 --> 00:04:01,000 there are two sets of passwords here. 37 00:04:01,050 --> 00:04:07,900 Once you've created it then you can go in and log in to your own application express workspace. 38 00:04:08,090 --> 00:04:12,650 Here's indie credentials that you've created. 39 00:04:12,650 --> 00:04:12,930 All right. 40 00:04:12,950 --> 00:04:15,970 Let's start the creation of the workspace. 41 00:04:16,260 --> 00:04:26,520 So here is asking for the database user is saying here if you are using an existing schema that is a 42 00:04:26,520 --> 00:04:33,490 ski mallow's Already in the database you can select reuse the existing Arthel. 43 00:04:33,540 --> 00:04:39,440 Yes we Im going to do all right as to use existing schema. 44 00:04:40,020 --> 00:04:43,890 Then you select schema scheme from the list. 45 00:04:43,910 --> 00:04:49,340 If the scheme is listed so will click on the database here. 46 00:04:49,520 --> 00:04:52,210 Up in there. 47 00:04:52,230 --> 00:04:54,440 So here I am using. 48 00:04:54,450 --> 00:04:59,810 Sorry this scheme I am using is asking for a database user. 49 00:05:00,250 --> 00:05:07,300 So saying you can either create a new database user or you can use an existing ones so Im going to use 50 00:05:07,300 --> 00:05:08,640 an existing one. 51 00:05:09,040 --> 00:05:13,920 I know we've got two databases user name quad here chart which we unlocked. 52 00:05:13,990 --> 00:05:23,590 Well we are locked scheme and then the database user name makes we need to set up the application express 53 00:05:23,660 --> 00:05:25,370 user name which is different. 54 00:05:25,490 --> 00:05:32,850 That is the user name for the workspace some good to set mind to blue line. 55 00:05:35,650 --> 00:05:44,210 Okay so this will be my application express user name so I need to set the password. 56 00:05:44,980 --> 00:05:50,500 Okay so I've entered my password and I have confirmed my password. 57 00:05:50,560 --> 00:05:59,080 So notice here using an existing database user which is how they are and also mostly This should go 58 00:05:59,080 --> 00:06:02,280 give me the hey char scheme as well. 59 00:06:02,530 --> 00:06:07,990 So once I've got that I need to click on this button here that says Create. 60 00:06:08,020 --> 00:06:10,870 If it is happy it will create the workspace. 61 00:06:10,870 --> 00:06:15,460 If it is not it will complain and tell me where I went wrong. 62 00:06:15,670 --> 00:06:18,150 So utterly concrete. 63 00:06:19,060 --> 00:06:27,850 Okay it looks like it is happy get in a prompter's save this oncall go I say never lucio says successfully 64 00:06:27,850 --> 00:06:29,640 created workspace here. 65 00:06:29,690 --> 00:06:37,200 Ah so the name of my workspace is called Hey char and you two things here to begin. 66 00:06:37,210 --> 00:06:38,760 Click here to log inside. 67 00:06:38,770 --> 00:06:40,860 Click there to log in. 68 00:06:40,930 --> 00:06:49,570 So tells me my workspace is hey char the user name is Blue Line and the password is password I set. 69 00:06:54,790 --> 00:07:03,660 Then click logging issue log me into my workspace so I am now into all my own private workspace so this 70 00:07:03,660 --> 00:07:05,010 is your workspace. 71 00:07:05,190 --> 00:07:07,970 And he tells you here WorldCom blew a line. 72 00:07:08,140 --> 00:07:10,820 So this is the blue line workspace. 73 00:07:10,830 --> 00:07:18,160 So this is where I will create my applications or develop any feen I require. 74 00:07:18,360 --> 00:07:23,300 This is because Miller is straight or this is administrator console tab. 75 00:07:23,580 --> 00:07:31,800 I can manage the services from here I can manage users and groups it can create users and group as the 76 00:07:31,800 --> 00:07:40,450 administrator and also specify the permissions or what they have access to perform. 77 00:07:40,620 --> 00:07:41,830 So that is it. 78 00:07:41,850 --> 00:07:47,660 We have successfully created a workspace in or a call application. 79 00:07:47,680 --> 00:07:50,450 Express thank you so much for watching. 80 00:07:50,470 --> 00:07:51,470 Bye for now.