====== Oracle Scripts ======
<code>
Oracle password has expired
jwars has a profile of DEFAULT
alter profile DEFAULT limit password_life_time UNLIMITED; ⇐==== passwords never expire
alter user jwars identified by password account unlock; ⇐============= works
username/password is jwars/password !!!!
</code>
<code>
 -- get all tables
SELECT owner, table_name FROM all_tables 
</code>
<code>
 -- get table space usage
SELECT a.tablespace_name, a.file_name, a.bytes allocated_bytes, b.free_bytes FROM dba_data_files a, (SELECT file_id, SUM(bytes) free_bytes FROM dba_free_space b GROUP BY file_id) b WHERE a.file_id=b.file_id ORDER BY a.tablespace_name;
quit; 
</code>
<code>
 -- describe a table in another schema:     
describe user2.flights;
</code>
<code>
 -- “creates sql”
select 'select count(*) from '||table_name||';' from all_tables where owner = 'JWARS'; x
</code>
<code>
 -- fix ora-28000. account get locks after 10 failed logins.
alter user jwars account unlock; 
</code>
<code>
 -- get all tables
SELECT owner, table_name FROM all_tables 
</code>
<code>
 -- get all tables
SELECT owner, table_name FROM all_tables 
</code>
<code>
 -- get all tables
SELECT owner, table_name FROM all_tables 
</code>
<code>
 -- get all tables
SELECT owner, table_name FROM all_tables 
</code>
  * SELECT owner, table_name FROM all_tables where owner in ('JWARS') - get all tables
  * 
  * select 'select count(*) from '||table_name||';' from all_tables where owner = 'JWARS'; "creates sql"
  * SELECT a.tablespace_name, a.file_name, a.bytes allocated_bytes, b.free_bytes FROM dba_data_files a, (SELECT file_id, SUM(bytes) free_bytes FROM dba_free_space b GROUP BY file_id) b WHERE a.file_id=b.file_id ORDER BY a.tablespace_name;
quit; get table space usage
  * describe a table in another schema:     describe user2.flights;
  * select table_name, num_rows counter from dba_tables where owner = 'XXX' order by table_name;
  * alter user jwars account unlock; fix ora-28000. account get locks after 10 failed logins.
  * ora-01017 - user/pass are now case sensitive

== count JWARS rows ==
<code>
column table_name heading 'table name' 
column table_name format a30
column num_rows heading 'num_rows'
select table_name, num_rows from all_tables where owner in ('JWARS');
quit;
</code>
<code>
select owner, table_name, nvl(num_rows,-1) from all_tables where owner in ('JWARS') order  by table_name;
quit;
</code>