How to Check Tablespace in Oracle SQL Developer?

How to Check Tablespace in Oracle SQL Developer?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

If you want to check tablespace in Oracle SQL Developer, then you must have the DBA privilege. You can use the SYS and System user to view the tablespaces information or grant the DBA privilege to any user from SYS user, the below is an example:

Grant DBA to SCOTT;

Check Tablespaces in Oracle SQL Developer

SQL Developer version 18.2 used for this example.

  1. Open Oracle SQL Developer and connect to the database by the user having DBA privileges to check the tablespaces information.
  2. Then on the left side in the connections panel, do right click on the username by which you connected.
  3. From the shortcut menu, choose Manage Database option.
  4. Then on the right side, it will open a window displaying tablespaces information as shown in the below screenshot.

Check tablespaces in Oracle SQL Developer.

See also: