For good DBAs, everything are same except the database name, while for bad DBAs, everything are different except the database name. Of cause we have good DBAs, but we still hit some problems. There are a lot of...
When posting scripts or query result to blog (Many DBAs have personal blogs), I always use an UltraEdit macro to format it, it will give us good text align. The macro defination is very simple, first step is...
There are lots of database (including Oracle, Sybase, and all the SQL Servers etc) running on Windows platform, and there are a lots of DBA tools wrote in Perl language. To use them on Windows, you need to...
By DBMS_LOB PL/SQL package I cannot load client OS files to LOB columns, you can either use lobs utility, or use Oracle's SQL Loader (sqlldr) to do this job. I have the following OS files in...
Perl is very popular programming language for DBA scripts and tools, following are the code of how to connect to different database with DBI. There is something special for the DBD-Sybase driver. DBI->connect('DBI:Oracle:tnsname', $user, $pass); DBI->connect('DBI:mysql:database=;host=;port=', $user, $pass);...
To get the maximum performance of Oracle SQL Loader (sqlldr), take the following into account. Use fixed width column text file such as following. 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON ...
There are lots of database running on Windows, and lot's of useful utilities developed for Windows. Sometime DBAs need to schedule a utility to run at specific time. For example, extract data to text file for data warehouse...
One of our batch job get the following error when calling sqlldr to load text file into database. % 9205/bin/sqlldr *****/*****@***** control=testsqlldr.ctl data=..... SQL*Loader: Release 9.2.0.5.0 - Production on Tue Aug 7 18:00:35 2007 Copyright (c) 1982, 2002,...
DBVerify (dbv) is an utility in standard Oracle binary to check whether there is any block corruption in the data file. I use it often in the following case. After building standby, dbv all the files...
I get this question from oracle-l groups about how to put "Sep 17 2007 7:00:00:020AM" (values from Sybase database) into an Oracle date column.. After several retries, I am be able to load it now. I create a...
