Last week I had a chance to work on RMAN to duplicate the existing 3-node RAC database to another 2-node RAC database. In my case, the 2-node target already has running instances, the task here is to wipe out and copy data from production. Here is my note. I tried to put some comments to …
You can change the width of the NAME, TYPE and VALUE of “show parameter” in SQL/Plus. SQL> show parameter sga NAME TYPE —————————— —————————— VALUE—————————— lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M sga_target big integer0 SQL> column NAME_COL_PLUS_SHOW_PARAM format A20 SQL> column TYPE format A20 SQL> column VALUE_COL_PLUS_SHOW_PARAM format A20 SQL> show …
Change column width of show parameter in SQL Plus Read More »
There are lot of articles (example) talking about how to read a physical XML file and insert into Oracle database. Here is a little bit different. This shows you how to read XML directly from web’s URL then insert into a database table without involving a physical XML file. To manage the list of URLs, …
Well, I believe most of DBAs including myself do not want to create Oracle sample schemas when creating a database. Why bother because we thought we would never use those sample schemas anyway. However, recently I’m running into an issue when trying to use tutorials on Oracle Data Mining (ODM). It requires the Sale History …
