I’ve been using Power BI for a couple months now, not as a developer, but as a system architecture. I may not deal with dashboard and report development on a daily basis, however, I, as an end user, use Power BI extensively to monitor Azure and Power BI usage including audit and billing. I would […]
Author Archive | ittichai
Rename all exported files to their original names after exporting from Oracle database using Oracle SQL Developer’s Shopping Cart
If you’re searching for “export Oracle BLOB”, the article, by Jeff Smith, titled “Exporting Multiple BLOBs with Oracle SQL Developer” using Oracle SQL Developer” is usually at the top of the search result. The SQL Developer features the Shopping Cart without using scripts to export BLOBs out of a database. I don’t want to go […]
JDBC connection samples in Oracle Enterprise Data Quality (OEDQ) to Oracle Service Name and MS SQL SSL
This post is just a quick note to myself on how to configure JBDC on Oracle Enterprise Data Quality (OEDQ) to connect to different databases. First let’s talk about connecting to Oracle database. By default, OEDQ’s Data Store can only connect Oracle database by SID, but not by Service Name. Fortunately, the JDBC connection […]
Install APEX’s Sample Packaged Application by Importing its SQL Script
If for some reason, you could not install the APEX sample packaged application via Application Builder > Packaged Applications interface, you have an option of installing it by importing the SQL script (fxxxx.sql). In my case, when installing via the Packaged Applications interface, I got the following error: While working with DBA and Oracle support […]
Oracle Database Gateways 11g R2 (11.2) Installation and Configuration for heterogeneous connection from Oracle to Microsoft SQL database
Installation Install the Oracle Database Gateways 11g R2 (11.2). See the screen snapshots of the installation here. Configuration During the installation, the following+ default initialization parameter file is created: [ORACLE_DG_HOME]\dg4msql\admin\initdg4msql.ora dg4msql = Database gateway for Microsoft SQL Server. If you choose a different database option, use the appropriate path name. Copy initdg4msql.ora to a new […]
How long did Oracle materialized view refresh run?
The LAST_REFRESH_DATE column of the DBA_MVIEWS or the LAST_REFRESH column of the DBA_MVIEW_REFRESH_TIMES indicates the start refresh time. But what if we’d like to find out how long the refresh of the materialized view really takes. Well, we can query the DBA_MVIEW_ANALYSIS. For Complete Refresh, the refresh duration will be in the FULLREFRESHTIM column of […]