I'm having the same problem with this question: Where SQL Developer saves the DB file? but since I do not have points to comment on, and ask for it myself, start a new "topic".
I've tried to do it the way the answer says, however, since I'm an Oracle startup user, I think I'm doing it wrong.
SELECT owner,tablespace_name
FROM dba_segments
WHERE owner = 'SEUSCHEMA'
GROUP BY tablespace_name,owner
Para saber qual é o datafile:
SELECT ddf.file_name
FROM sys.dba_data_files ddf
WHERE ddf.tablespace_name = 'NOME_TABLESPACE'
If I run these snippets in the tool (SQLDeveloper), it returns me empty columns. I believe I should replace% with% 'SEUSCHEMA' and WHERE owner = 'NAME_TABLESPACE' , by some name I set at some point in the database, but I do not I know for what to replace, I read the documentation to understand, but it did not make me clear what to do.
To clarify my problem, what I want to do, is to be able to choose where to save the BD file, or at least find it and copy the database file so that I can place it -