Solaris 10 zones - High Kernel time.117 (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 Utility610 (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 vi1452 (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-up426 (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 conditions730 (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 VI349 (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 process142 (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 query128 (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 issue241 (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
Clean-up dba_datapump_jobs440 (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)
SQL Server for Oracle DBAs9854 (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 system1152 (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 uppercase353 (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 Server356 (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)
SQL Agent job RAISEERROR roll-up426 (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 vi1452 (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 Utility610 (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)