This example, tested on Oracle 11, shows how you can define bind variables in SQL*Plus, assign values to them in PL/SQL then display those values afterwards back in SQL*Plus:
SQL> variable bv1 varchar2(3)
SQL> variable bv2 number
2 select 'ABC' into :bv1 from dual;
3 select 123 into :bv2 from dual;
PL/SQL procedure successfully completed.
SQL> print bv1
SQL> print bv2
I wanted to test the effect of RMAN backup compression on an Oracle 22.214.171.124 database running on Windows. I configured the flash recovery area, closed the database and mounted it. Then I did a backup without compression:
C:UsersAJ0294094>rman nocatalog target=andrew/reid
Recovery Manager: Release 126.96.36.199.0 - Production on Fri Mar 11 18:42:42 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
The second new item is the UNDO tablespace. This is a special tablespace that is only used for internal purposes and one that users cannot put any tables or indexes into.
This seemed perfectly reasonable so I wondered what might happen if I tried to do it. In an Oracle 188.8.131.52 database Oracle returned (more...)
I went on my first DBA course in 1997 and the lecturer there explained that readers do not block writers in an Oracle database. I had an issue recently which appeared to contradict this so I have reproduced it below in an Oracle 184.108.40.206 database.
I noticed in OEM that there was some issue in the database. As usual, click on the images to enlarge them and bring them into focus (more...)
I went to the UK OUG Conference for the first time around 12 years ago, in 2003 if I remember correctly. I enjoyed all the presentations but the two which stuck in my mind were by Jonathan Lewis and Connor McDonald.
This year I will be chairing 8 sessions there, which means I will be introducing the speaker and making sure nothing goes wrong.
Two of these sessions are on 6th December 2015, which is (more...)