create a tablespace in Navicat for Oracle

2 years ago
William Carter
1 minute

To create a tablespace in Navicat for Oracle, you can follow these steps:

  1. Open Navicat for Oracle and connect to your database.
  2. Select the database where you want to create a table space in the object explorer on the left.
  3. Right-click on the “tablespace” node and select “create tablespace”.
  4. Tablespace name: Enter the name of the tablespace to be created.
  5. Data file: Select the data file where you want to store the tablespace. You can choose an existing data file or create a new one.
  6. Initial size: refers to the initial size of the specified tablespace.
  7. Automatic increase: choose whether to allow the table space to increase automatically.
  8. Maximum Size: Specifies the maximum size of the table space.
  9. Storage parameters: Select storage parameters for the tablespace, such as block size and segment size.
  10. Click the “OK” button to create the tablespace.

After completing the above steps, Navicat for Oracle will create a new tablespace in the selected database. This tablespace can be used to create tables, indexes, and other objects.

bannerAds