How can I resize a tablespace in Oracle?

2 years ago
William Carter
1 minute

To resize an Oracle tablespace, you can follow these steps:

  1. Open a database client tool such as SQL*Plus or Oracle SQL Developer.
  2. Log in to the target database with administrator privileges.
  3. Show the names of the tablespaces in the database.
  4. Retrieve the total, free, and used space in megabytes for a specific tablespace from the database.
  5. Modify the size of the tablespace to 100MB.
  6. Choose the tablespace_name and calculate the Total, Free, and Used space in MB and display the results for the specified tablespace_name from the dba_free_space table.
  7. Close the database client tool.

Before adjusting the size of the table space, ensure that there is enough disk space available and proceed with caution to prevent data loss or the database becoming inaccessible.

bannerAds