(Brian Peasland) In a data warehouse environment what is the best way to extract data for a specific period and populate to another database? I don’t want the entire schema or full database, only a few tables with one month’s data and respective table views and indexes. (R)
Tag: Oracle
Sequences in Oracle 10g RAC
(Christo Kutrovsky) Just recently I got a call from a developer. He had a table with a primary key populated by a sequence, a timestamp column with the current date and some other columns. He had a specific set of data that, when ordered by the primary key had out of order timestamps. He was puzzled
Understanding Directives and More with the Oracle HTTP Server
(Sam Alapati) Web servers can serve static and dynamic content, with most of the static content being stored on the server (corresponding to the default htdocs directory) and the dynamic content being generated on the spur of the moment, usually with the help of data from databases, for example. Con
Rman Admin and Backup Script for RAC on ASM
(Alejandro Vargas) This script does a couple of Admin activities, then make a backup ‘as copy’ to File System.
Oracle SQL Developer vs. Toad: Users speak out, part two
(Mark Brunelli) Oracle developers are still speaking out about their favorite PL/SQL editing and debugging tools, and their opinions truly run the gamut. (R)
Oracle RAC Administration – Part 14: Services Architecture in Workload Management
(Tarry Singh) There is a lot of hype on Virtualization. It is a $20 Billion market and although heavy transaction intensive applications and Oracle RAC may not find its place in your Virtual Infrastructure today, someday they surely will. Disk Virtualization, Network Virtualization, not only address
Accessorize Oracle Database with Ruby
(Dustin Marx) Dynamic scripting languages are enjoying a surge in popularity, because they provide powerful features and enable rapid development. Recent interest in the Ruby on Rails framework has brought Ruby into the forefront for the software development community. However, Ruby can be used for
Oracle Database 10g powers growing MySpace.com competitor
(Mark Brunelli) Michael Birch is relying on Oracle Database 10g to help his small company overtake MySpace.com’s position as the largest social network in the United States. (R)
Using the new JSF Components ShowDetailFrame and PanelCustomizable for structuring the User Interface in JDeveloper 10.1.3.2
(Lucas Jellema) One of the interesting new features that come along with WebCenter in JDeveloper 10.1.3.2, but hopefully are not necessarily part of WebCenter (licence) is the set of Customizable Components: PanelCustomizable and ShowDetailFrame. These two components make it very easy to organize th
Invalid GROUP BY queries
(Rudy Limeback) I have a single (Oracle 9i) table which captures events with the following columns: Source (VARCHAR) Event (VARCHAR) Time_Of_Event (timestamp) a number of other detail columns, call them Detail1, Detail2, etc. (R)
