Where does SQL Developer save the BD file?

Question

Where are the banks I create in SQL Developer saved ? I wish I could choose the location/folder to save the Bank, but I don’t know where it is saving.

Answer 1

Basically, the oracle saves data from its schemas inside tablespaces, of which the datafiles, which are physical files, and sometimes shared between schemas.

To know which tablespace your schema this using, can run the script:

SELECT owner,tablespace_name
  FROM dba_segments
 WHERE owner = 'SEUSCHEMA'
 GROUP BY tablespace_name,owner

To know what the datafile:

SELECT ddf.file_name
  FROM sys.dba_data_files ddf
 WHERE ddf.tablespace_name = 'NOME_TABLESPACE'

You’ll get a return similar to:

/u01/app/oracle/oradata/orcl/name_do_datafile.dbf

---

To choose the location to save, you will need to see the directories that has available on Oracle:

SELECT *
  FROM dba_directories

to create a new oracle directory, just use the oracle script:

CREATE OR REPLACE DIRECTORY NOMEDOMEUDIRETORIO AS '/caminho/pasta/meubanco';

So when creating your bank, just choose your new directory.