Where are the databases saved in SQL*Plus?

Question

I downloaded SQL*Plus on the Oracle website, installed (my notebook is Windows 10) created user and already created some banks, but do not know where it saves the banks I created. Where is?

Answer 1

In no place. The SQL*Plus is a utility for using commands, mainly in scripts to manipulate databases. It is not a database, so there is no reason to be somewhere.

Must have created databases on Oracle Database through SQL * Plus. His files can be anywhere. You can configure this. The most appropriate is to refer to where they were installed. You can refer to SQL*Plus:

select name from v$datafile;

Also consult by:

select value from v$parameter where name = 'db_create_file_dest'

Another possibility:

select * from dba_data_files;

I put in the Github for future reference.

There’s a documentation on the subject.