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