Hello everyone,
I was wondering if anyone had any suggestions. I have what appears to be a missing tablespace however the datafiles that are associated with the tablespace are still on my server. When I query the Oracle database to show all my tablespaces, my tablespace is not listed. However when I look at the datafiles they are still being modified or at least appear to be modified as they will have a current date and time.
I tried mounting the database and running the following "ALTER DATABASE DATAFILE '/oracle_data/hdbt1.ora' ONLINE" and then opening the database and querying the tablespaces again to see if it showed up and it did not. I am not getting any errors or anything of missing datafiles. Any suggestions?