How to create an Oracle tablespace in the console ____oracle

Step 1 2 3 4 5 6 7 8

Oracle databases are divided into logical regions called table spaces-the logical structures that form Oracle databases. An Oracle database can have one or more tablespaces, while one table space corresponds to one or more physical database files. The tablespace is the smallest unit of Oracle database recovery, accommodating many database entities, such as tables, views, indexes, clusters, fallback segments, and temporary segments.

Tools/raw Materials

Oracle 11g

Method/Step

Open the IE Input console URL (https://IP:1158/em/) and log on to the Oracle console with a user with DBA authority

Landing Console Home is the general information of the Database Information monitoring screen, here you can view the database CPU, memory, session and other monitoring parameters

Click on the "Server" tab, click "Table Space" under Storage to enter the table space management interface

The table space management interface can edit and delete existing database table spaces. Click the "New" button in the upper right corner to enter the table space creation window. Enter the name of the table space in the name. Zone management Specifies whether the current tablespace is local administration or dictionary management. Specifies the table space type. You can select one of three options: "Permanent" (allows you to set another option, specify the table space as the default permanent table space, temporary (allows you to set another option, designate the tablespace as the default temporary tablespace), and restore (by which you can choose to set the restore retention time guarantee to Yes or no ”)。

Click the "Add" button below to configure the storage space for the database.

In addition, enter the table space, path, file size. Automatically expands the data file when it is full (allows you to automatically expand the size of the data file when the data file is full). If you select this option, you can specify the size of the file you want to increase by using the Increment field (Specify the size of the capacity increment to add to the data file each time you apply the Autoextend option), the maximum file size (specifies the maximum size of the file when you use Autoextend.) You can optionally specify the size as unrestricted, or you can enter a value in the Value field.

After the store is set up, click the Continue button to return to the Table Space page, and then click "OK" button to complete the creation of the table space, the table space created after the system will generate a new record in the table space