For various reasons it is important that your Windows computer name persists across instance shutdown on EC2 (listener, tnsnames.ora, loopback adapter etc.). To achieve this you need to perform the following steps: 1. Connect to your instance via remote desktop 2. Change the computer name via control panel 3. Open windows explorer and browse to the EC2 config tool. By ...
SOAP web services dominate in a SOA environment. However, there is a new kid on the block: REST. This is a more lightweight approach to exchange data over HTTP, which is becoming more and more popular with web mashups and the web 2.0 in general. Amazon, Twitter, Yahoo all expose their APIs via REST. REST is an architecture style for ...
The script below will create a date dimension in just one SQL statement. We don't use performance-killer nonsense such as cursors, functions etc. We just pick a start date and the number of days we want to create and with a bit of magic of the Connect By clause and the NUMTODSINTERVAL function we do the whole thing in 14 ...
The following steps need to be taken to be able to delete archived redo logs that are no longer required by the CDC capture process: 1. Determine the new first_scn for your capture process
FROM DBA_CAPTURE cap, CHANGE_SETS cset
WHERE cap.CAPTURE_NAME = cset.CAPTURE_NAME
As per Oracle documentation: This query "determines a new first_scn value that is greater than the original first_scn value and less than or equal to ...
- Page 2 of 2