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:

Advertisement
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.

Advertisement

See also:

Related:  How to Create Procedure in Oracle SQL Developer?

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.