I'm not a Unix expert, but we have installed an Oracle DB on Linux server. we ran a script that created a lot of oracle schemas inside a database called: demo.
I am logged on to that database server and using Sqlplus to login as SYSTEM.
I would like to be able to view all the schemas that were created and also to be able to change the password for some of them.
could you please provide some commands on how I can do this type of DB admin tasks direclty from the sqlplus command line?