Press "Enter" to skip to content

How to Check Tablespace in Oracle SQL Developer?

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:

Vinish Kapoor

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *