by Jason L Froebe on February 15, 2013, no comments
The most intuitive way to write a comparison of two tables and spit out the # of rows that are the same involves a left join: select ‘Investment’ as TableName, count(*) as RowCount from Investment_A a, Investment_B b where a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = b.col3 AND a.col4 = b.col4 This [...]
by Jason L Froebe on November 28, 2011, no comments
Position Responsibilities • Manage database configurations, schemas, and space • Manage database and system alerts. • Support new application code releases / builds in various production and non-production environments • Provide performance tuning, problem research/resolution, code reviews and deployments, SQL support, and data movement • Manage database changes for releases and new projects • Provide [...]
by Jason L Froebe on May 6, 2010, 3 comments
It is really really easy to change the default NLS_DATE_FORMAT setting but to be honest, you should set it at a session level IMHO. We basically just need to run “ALTER SYSTEM SET NLS_DATE_FORMAT=’YYYY-MM-DD’ SCOPE=SPFILE” as a user with sysdba privileges. If you started the Oracle instance without a spfile (it should be located at [...]
by Jason L Froebe on April 5, 2010, no comments
On the source machine: Set the tablespace(s) into read only mode SQL> Alter tablespace <tablespace> read only Export the tablespace meta data using export % expdp system/<password> DUMPFILE=expdat.dmp DIRECTORY = dpump_dir TRANSPORT_TABLESPACES = <list of tablespaces separated by commas> TRANSPORT_FULL_CHECK=Y If the dumpdir is not set up, you will get an ‘invalid’ directory error: SQL> [...]
by Jason L Froebe on March 10, 2010, 6 comments
I was trying to install Oracle 11g client on to a WinXP box but Symantec Antivirus wouldn’t let me because it thought it was infected with over 800 viruses. Same file was marked clean on another box. So, I picked several of the viruses it said was infected with and looked for any evidence of [...]