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;