Hot answers tagged oracle-11g
3
11g has the pivot construct, which appears to meet your needs:
with pivot_data as (
select buildnumber, testname, status
from testresults)
select * from pivot_data
pivot (min(status)
for buildnumber
in ('1' as build_1, '2' as build_2, '3' as build_3)
)
order by 1;
Note the min(status), the pivot requires an aggregate function, ...
1
You could use Oracle Data Pump Export and unload data compressing the resulting dump file(s). Below is an example of unloading the tables EMPLOYEES and DEPARTMENTS owned by the user HR:
expdp hr parfile=hrexp.par
The parameter file hrexp.par contains the following parameters:
content=data_only
compression=all
include=table:"IN ('EMPLOYEES', ...
1
TL;DR to be able to restore data+undo without overwriting the entire current undo.
When you perform RMAN online backup, some transactions are in the middle of processing, they did change something but not yet performed their COMMIT. Transactional model of work ("atomicity") requires those transactions to be rolled back (completely undone) on recovery. ...
Only top voted, non community-wiki answers of a minimum length are eligible
