Let's discuss how to create an Oracle tablespace.

During project implementation, tables are generally designed. Different from general databases, Oracle table space statement. A tablespace is the space used to store tables. When creating a table, we can create a new tablespace to store the table in order to be different from the original Oracle tablespace. It is generally recommended to create two tablespaces, one for data storage and one for index storage.

To create an Oracle tablespace, follow these steps:
1. It can be implemented through the graphical user interface provided by Oracle. For more information, see the Oracle Enterprise Console.
2. Implemented through statements

For example:

 
 

  
  
CREATE TABLESPACE "HHSCINFO"  
  
  
LOGGING  
  
  
DATAFILE 'D:\ORACLE\ORADATA\INFOPLAT\HHSCINFO.ora' SIZE 512M  
  
  
EXTENT MANAGEMENT LOCAL 
 
 

A new "HHSCINFO" tablespace is created. The data file storage location is D: \ Oracle \ ORADATA \ INFOPLAT \ HHSCINFO. ora. The size is 512 MB.

After creation, you can refresh to see if the creation is successful. If you find that your space is too small, you can modify the Code as follows:

 
 

  
  
ALTER DATABASE  
  
  
DATAFILE 'D:\ORACLE\ORADATA\INFOPLAT\HHSCINFO.ORA' RESIZE  
  
  
1024M 
 
 

Of course, you can also perform operations on the GUI. Generally, when creating a tablespace, select the tablespace auto-incrementing AUTOEXTEND and specify the size. After creating a tablespace, we also need to create a new user and grant the relevant permissions to the user.

 
 

  
  
CREATE USER InfoManager IDENTIFIED BY admin  
  
  
DEFAULT TABLESPACE HHSCINFO;  
  
  
GRANT CONNECT TO InfoManager;  
  
  
GRANT DBA TO InfoManager;  
  
  
GRANT resource TO InfoManager; 
 
 

In this way, we can create a new table on this basis, which is relatively independent from other tablespaces.

1. Create and assign Oracle user permissions
2. Two solutions for Oracle password loss
3. Quickly implement the Oracle tablespace Transfer Function
4. Amazon pushes MySQL to meet the needs of relational databases
5. Explain how to use the Oracle user permission View