I installed Oracle XE 18c and SQL Developer 20.2. I created a new tablespace using SQL-Plus with the SYSTEM user. In SQL Developer I created a connection with the system user, and in SQL Dev DBA/Storage/Tablespaces, I use to see the tablespace I created for my development project.
Because I need a report, I was trying with Reports-User Defined Reports in SQL Dev. When I clicked for New Report, SQL Developer was asking me for a new connection. For some reason, I lost my old system@ORCL connection. When I reconnected with the system@ORCL connection, SQL Developer doesn't show me my tablespace, tables, stored procedures and functions.
I did try with SQL-Plus with the following query and I can see that my tablespace, tables, records and data file are still there, but SQL Developer can't see, read and access my tablespace, datafile and objects in it.
SELECT DISTINCT sgm.TABLESPACE_NAME , dtf.FILE_NAME
FROM DBA_SEGMENTS sgm
JOIN DBA_DATA_FILES dtf ON (sgm.TABLESPACE_NAME = dtf.TABLESPACE_NAME)
WHERE sgm.OWNER = 'USERNAME ex. SYSTEM'
The question is:
How can I reconnect to my tablespace in SQL Developer?
Thanks,
Kristine