Oracle - commands

Login to oracle command line:
su - oracle
sqlplus / as sysdba

Commands:
The syntax for changing a password in Oracle is:

ALTER USER user_name IDENTIFIED BY new_password;

Get a tables and filter owner, which you don't want to see.:

SELECT owner, table_name from dba_tables where not regexp_like (owner, 'ONETABLE|SECONDTABLE|ANOTHER|TABLEB|EXAMPLE');


Get a last time of ussing/modification of table.

select INSERTS,UPDATES,DELETES,TRUNCATED,TIMESTAMP from dba_tab_modifications where TABLE_OWNER='EXAMPLEOFTABLE';


List all users that are visible to the current user:

SELECT * FROM all_users;