![]() |
Main /
OracleTo Start Oracle> su - oracle > sqlplus /nolog sqlplus> connect / as sysdba; sqlplus> startup; sqlplus> exit; > lsnrctrl start To get all columns for a table
to get all tables
Change oracle memory
Make read only partitioned tabled writable againselect 'alter tablespace ' || tablespace_name || ' read write;' from dba_tablespaces where status = 'READ ONLY'; CLOBSdbms_lob.substr(debug.ERROR, 6, 1) = '<ERROR' to see what sql was just run:select * from v$sql order by first_load_time desc; |