Oracledb11_home1 create tablespaces and users

Oracledb11_home1 create table space and user 1 start em

ClickStart --> program --> Oracle --> oradb11g_home1 --> Database Control-orcl; 1:

 

(Figure 1)

Figure 2 appears after clicking

 

(Figure 2)

 

2. Log On With a supermanager

Log On with the super administrator in Figure 2.

For example:

Username: sysatem;

Password: the password used to create a database.;

This is the default connection identity. Figure 3 appears after login

 

(Figure 3)

 

3. Create a tablespace

Click"Server"Tab to go to Figure 4

(Figure 4)

 

InStorage.TablespaceClick in 5

(Figure 5)

ClickCreateButton to go to figure 6

(Figure 6)

InNameEnter the name of the tablespace. The following options are selected based on your needs."Data file"Click
AddClick to go to figure 7;

(Figure 7)

Enter relevant information as needed and click continue to go to figure 8.

(Figure 8)

 

ClickOKYou can see the created tablespace in Figure 5.

 

4. Create a user

In Figure 4SecurityClick belowUserFigure 9

 

(Figure 9)

ClickCreateGo to figure 10

(Figure 10)

 

Then clickRoleTab to go to Figure 11;

(Figure 11)

 

ClickEdit list12

(Figure 12)

 

Select the role you want to assign to this user from the available roles and click OK.

 

5. Summary

Now you can create a tablespace and a role.

 

The tables created after logging on to the database using the role you just created will be saved in the tablespace that you think is located here.