How to create table space in navicat

Steps to create a tablespace in Navicat: Connect to the database and navigate to "Tablespace". Right-click the Tablespaces folder and select New >Tablespace. Specify the table space name, add data files, and configure other settings in the Table Space dialog box. Click OK to create the tablespace.

How to create a table space in Navicat

Create a table space

Step 1: Connect to the database

• In Navicat, click the "Connect" button, enter the database server information and establish a connection.

Step 2: Navigate to "Tablespace"

• In the database tree, expand the "Database" node and select "Tablespace" .

Step 3: Create a new table space

• Right-click the "Table Space" folder and select "New" > "Table Space ".

Table Space Properties

In the Table Space dialog box, specify the following properties:

• Table Space name: Enter the name of the new table space.
• Files: Click the "Add" button to add one or more data files.
• Initial size: Specify the initial size of the data file in MB.
• Auto-grow: If desired, enable the auto-grow option and specify the growth increment.
• Maximum size: Set the maximum size limit for data files.

Additional Settings

In the Options tab, you can configure additional settings:

• Log: Specify whether to enable logging.
• Persistence: Specifies whether the tablespace survives a reboot.
• Read and write permissions: Control access permissions to the table space.

Complete creation

Click the "OK" button to create the table space. After successful creation, the tablespace will be displayed in the "Tablespace" folder.

The above is the detailed content of How to create table space in navicat. For more information, please follow other related articles on the PHP Chinese website!