Where are banks saved in SQL * Plus?

Question

Where are banks saved in SQL * Plus?

Navigation

#1 by (1 votes)

1

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

sql oracle

asked by anonymous 15.09.2016 / 18:34

1 answer

Why does hibernate not list results if the select query calls null field of the table? touchend as mouseleave not to enable onClick effects in jQuery

score 1 · Accepted Answer

Nowhere. SQL * Plus is a utility for using commands, especially in scripts to manipulate databases. It's not a database, so it does not have to be somewhere.

You should have created databases in Oracle Database through SQL * Plus. His files can be anywhere. You can set this up. The most suitable is to consult where they have been installed. You can query for SQL * Plus:

select name from v$datafile;

Also check for:

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

Another possibility:

select * from dba_data_files;

There is a documentation on the subject .