• View
• Edit
• History
• Print

Oracle

To Start Oracle

> su - oracle
> sqlplus /nolog
sqlplus> connect / as sysdba;
sqlplus> startup;
sqlplus> exit;
> lsnrctrl start

To get all columns for a table

• select * from all_tab_columns where table_name = upper(:String__table);

to get all tables

• select * from all_all_tables;
• select table_name from all_all_tables where owner='SIMON';
• select * from tabs;
• SELECT table_name FROM user_tables; (tables in users schema only)

Change oracle memory

• alter system set sga_target=600m

Make read only partitioned tabled writable again

select 'alter tablespace ' || tablespace_name  || ' read write;'
from dba_tablespaces
where status = 'READ ONLY';

CLOBS

dbms_lob.substr(debug.ERROR, 6, 1) = '<ERROR'

to see what sql was just run:

select * from v$sql order by first_load_time desc;