1
I’m having the same problem with that question : Where SQL Developer saves the BD file? more like I have no points to comment on, and ask right there, start a new "topic".
I tried to do the way the answer says, however, as I’m an early user on Oracle, I believe 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 WHERE owner = 'SEUSCHEMA' and WHERE ddf.tablespace_name = 'NOME_TABLESPACE', by some name I defined at some point in the bank, plus, I do not know what to replace, I gave a read in the documentation to understand, but did not make clear to me 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 I can put - it in the folder of my JAVA application.
It is not SQL Developer that saves the file, but Oracle itself. I think you do not understand how DBMS works, Oracle does not have a file only that you can embed in the application, it separates the data into several files managed by the database, to be accessed by the network, not to be transported.
– Júlio Neto
Just adding: if you need a bank that you can distribute with the application, you need to search for DB’s like H2, Firebird, Localdb, Sqlite.
– Júlio Neto
@Julio then no version of Oracle will give to distribute with the application ?
– JavaTech
I don’t know any "Embedded" version of Oracle, I know that Localdb is an Embedded version of SQL Server, but Oracle has never heard of anything along these lines.
– Júlio Neto