Simple operation of Oracle installation and Web page creation table space and simple operation of Plsql

Installation of 1.oracle:

Installation is easy and easy to learn, not explained here. Wait patiently after downloading the package, note that the installation directory does not have Chinese characters, try to install according to the specified directory. When the installation is complete, it consumes approximately 5g of memory.

If you want to uninstall Oracle, you need to uninstall "Universal Installer" with its own uninstall tool, then delete the registry key, delete the environment variable, delete the directory, and restart the computer.

2. Create a tablespace in the Web version:

Go to Web version:

In the computer service we can see a total of 7 Oracle service projects, of which only three are being started. Of these three items, only when the ORACLEDBCONSOLEORCL is launched will we be able to access Oracle's Web version, the other two unrelated to this but the nosebleed starts or does not run Oracle. Login, username we can use the database at the highest level administrator sys, the password is set by ourselves. Category Select Sysdba.

To create a table space:

After entering, we only need to hit the server option, then click on the table space, there will be a (create) button on the left and right side, click on it. Then enter a name, then click Add in the lower right corner and enter the data file you want to create. Click OK. Create complete.

Simple operation of 3.plsql:

Open Plsql, we can create our own users in the user, after the creation is complete, we can log on to their own users. Our set of settings such as font size, remembering passwords, etc. are set in the preferences in the tool.

When creating a user, we also set a default tablespace, which you create in the Web version. Temporary table space we can choose Temp. Then we can right-click in the tables to create the form you want to create, as follows:

How to create it doesn't explain it, it's simple.

Simple operation of Oracle installation and Web page creation table space and simple operation of Plsql