jwilliam's articles:

Items(32) /4 Next >> Last >|

Solaris 10 zones - High Kernel time. 1 17 (2/20/2013 11:23:31 PM) comp.unix.solaris I don't have SYSADMIN rights as I am a DBA. I have a T4-1 with 4 VM's used for development. SYADMINS are being a little obstinate right now. Servers run fine much of the time; however, there are spurt... JAW

Purge Utility 6 10 (2/13/2013 8:44:32 PM) comp.databases.ms-sqlserver I have written a PURGE utility SPROC that works fine on simple SQL. I am trying to compose complex SQL. delete from PurgeUtility where TableName = 'TAB1' INSERT INTO [DB].[dbo].[PurgeUtility]([TableNam... JAW

Case/lower/upper in vi 14 52 (9/19/2012 3:00:41 PM) comp.unix.shell I have a file similar to the below with multiple entries of a similar nature. I want to change /riskops/RISKOPS to /risktss/RISKTSS in one VM command. I can do it easily in two. Just basically the same ... JAW

SQL Agent job RAISEERROR roll-up 4 26 (10/31/2011 6:51:36 PM) comp.databases.ms-sqlserver I have and SPROC that calls the below via a cursor so parameters can be based from a table. When in run it in SSMS it gives the desired results. Any file that errors it it continues on to the next which is wh... JAW

egrep and conditions 7 30 (5/4/2011 1:32:42 PM) comp.unix.shell The below example basically returns a zero return code when I get offset or gov. I am looking to get a zero return code only if offset and gov are in the display ntpq -p | egrep -e "offset|gov";echo $? Basi... JAW

Reverse fields in a file using VI 3 49 (4/13/2011 3:22:20 PM) comp.unix.shell In VI I want to use bufferes to grab the below and convert as shown as I have a large file to convert. From cp -p /u411/oradata/ORACLE/* /backup/ORACLE/cold/u411/.;print copy=$? To cp -p /backup/ORACLE/col... JAW

Tricky vi or awk process 1 42 (2/9/2009 3:17:27 PM) comp.unix.shell I have a large file with many examples of the below. In cases where there is no ALTER STATEMENT the ; terminator is as I needed so no changes are required. In cases where there is an ALTER that followings the ... JAW

Crazy data query 1 28 (9/22/2008 9:45:09 PM) comp.databases.oracle.server have an database column that is like the below and not normalized. So the entire address in in on field. Below is a sample of the data There is a space between each item. 4918 HULK PKY *LOT 34C BUGTUSEL GA ... JAW

sqlplus HTML format issue 2 41 (8/6/2008 11:11:00 PM) comp.databases.oracle.server I use the below to create output that can be read in HTML from MS EXCEL when I run a sql statement. It works good except this once SET LINESIZE 999 VERIFY OFF FEEDBACK OFF PAGESIZE 50000 SET MARKUP HTML ... JAW

PL/SQL issue with invalid results 4 37 (7/9/2008 4:43:56 PM) comp.databases.oracle.server I can run a query in SQPLUS and get results I need. Select col1 From tab1 sch, tab2 cmn where and cmn.joinid = sch.joinid AND completion_dtt... JAW

jwilliam's replies:

Items(14) /2 Next >> Last >|

Clean-up dba_datapump_jobs 4 40 (10/10/2007 4:56:52 PM) comp.databases.oracle.server I have two export jobs that don't have any sessions attached to them. I would like to get these two jobs out of dba_datapump_jobs I don't see anything at the moment. ---------------------------- ------------... jwilliam (49)

Trying to see if I can do the attached without PL/SQL 2 32 (1/25/2008 9:50:52 PM) comp.databases.oracle.server REM table q; create table q ( premise_no number, DUE_ON_DTTM date); -- Insert into q (PREMISE_NO, DUE_ON_DTTM) Values (966034975,TO_DATE('10/01/2007 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); Insert into q (PREM... jwilliam (49)

SQL Server for Oracle DBAs 98 54 (5/22/2008 6:54:19 PM) comp.databases.oracle.server Anyone can recommend some links, some books? We support about two dozen Oracle dbs, and seems like we'll be getting a few SQL Servers to look into, and are just not read to hire a SQL DBA yet, but we'll look i... netcomradeNSPAM (497)

List disks on a Linux system 11 52 (5/22/2008 7:54:40 PM) comp.os.linux.misc In solaris you can issue a format command to display the disks. In Linux RHEL5 or OEL 5; how would you do this? df -k is not quite what I need ... jwilliam (49)

copy converted filenames to uppercase 3 53 (6/2/2008 6:31:04 PM) comp.os.linux.misc I mounted a cd on a Linux machine and copied the files over. The filenames were orginally lower-case . However, Linux translated the file names to upper-case. Where can this be changed? ... jwilliam (49)

Software RAID on Linux Server 3 56 (6/11/2008 1:44:40 AM) comp.os.linux.misc I have a LINUX server running INTEL with 3 drives. It is going to be for a small Oracle environment. I don't want to use Oracle ASM at this point. I would like to STRIPE across the 3 drives that will be EX... jwilliam (49)

PL/SQL issue with invalid results 4 37 (7/9/2008 4:43:56 PM) comp.databases.oracle.server I can run a query in SQPLUS and get results I need. Select col1 From tab1 sch, tab2 cmn where and cmn.joinid = sch.joinid AND completion_dtt... jwilliam (49)

SQL Agent job RAISEERROR roll-up 4 26 (10/31/2011 6:51:36 PM) comp.databases.ms-sqlserver I have and SPROC that calls the below via a cursor so parameters can be based from a table. When in run it in SSMS it gives the desired results. Any file that errors it it continues on to the next which is wh... jwilliam (49)

Case/lower/upper in vi 14 52 (9/19/2012 3:00:41 PM) comp.unix.shell I have a file similar to the below with multiple entries of a similar nature. I want to change /riskops/RISKOPS to /risktss/RISKTSS in one VM command. I can do it easily in two. Just basically the same ... jwilliam (49)

Purge Utility 6 10 (2/13/2013 8:44:32 PM) comp.databases.ms-sqlserver I have written a PURGE utility SPROC that works fine on simple SQL. I am trying to compose complex SQL. delete from PurgeUtility where TableName = 'TAB1' INSERT INTO [DB].[dbo].[PurgeUtility]([TableNam... jwilliam (49)