Search results for query: *

I have long shell scripts . I would like to format the script to set correct indentation and spacing ?

Can anyone tell me how I send an email from AIX to an external address ? What do I need to setup ?

I have data consisting of various numeric fields (dec 8.2). I want to load them into an Oracle table dropping the decimal and making them char(8). My sql loader cntrl file defines them as ; Field1 char "to_char(:field1,'99999999')" But this does not work. I get error ; ORA-01401: inserted value...

I clone a db from one server to another as folows ; 1. shutdown immediate on server A (Solaris 8, Ora 9i) 2. copy all datafiles to server B (Solaris 8, Ora 9i) 3. startup creating new cntrl file Usually all is ok but sometimes it says that one of the datafiles needs recovery. Someone said that...

I am trying to write a database check that will send me an email message if there is any tablespace > 90% used. The email is not the problem. The problem is that I am trying to return either a TRUE flag or a count of tablespaces where % used > 90. Anyone got such a thing ?

I have a table of over 1 million records and the update_statistics command runs for many hours on it - even seems to hang at times. How can I improve this ? Are there any parameter settings that will help ?

I have a large table as follows Rec_Type Rec_Month Rec_Year Stuff A Oct 2004 sdsddsxfdfsdf A Nov 2004 tyytrtrt B Oct 2004 rgdrghgdfdf C Oct 2004 jtyjtjtrjtyjtyjty C Nov 2004 ererggdfg I want to select where...

I have a file with rec length of 2096. I can "more" the file but would like to "grep" it. How can I split a file vertically ie selecting each record bytes 1-1000 only (Note ; not lines 1-1000 but bytes or columns)

If I login as root - my environment is fine. If I login as another user and su without the - option, my environment is not set. What I want to do is set "alias rm -i" and "set -o vi" when I su (without using the - option).

My update_statistics command is running for hours. Is there a way to speed it up with parrallel tasks or buffers or anything ?

I have a job scheduled via cron. It runs fine but sends me a blank email every day. There are no echo or print statements in the job. Why am I getting this email and how do I stop it ?

Does anyone have a batch script that I can run daily to remove files that do NOT have the archive bit set ?

When I run optdiag, I get this message and optdiag aborts ; Cant get localized message Optdiag failed What is it looking for ? ---------------------------- This is my command and the resultant output file; >optdiag statistics recon -o recon.opt -Uid -Ppass >cat recon.opt OptDiag/12.5.0.3/EBF...

Why does this write each record on a separate line ? (note; only a small sample of actual script) sqlplus -S id/pass@sid << EOT >>/dev/null set heading off set pagesize 0 set linesize 132 set serveroutput off set verify off set feedback off spool fileout select vendor_name , vendor_alt from...

I want to validate this input (year comma month) ; 2004,06 and the validation must check for valid year 1999 - 2010 must check for a comma must check for valid month 01-12

I have a varchar that looks like this ; 2004-06-14-16.58.42.528000 How do I convert it to Sybase datetime ?

I need to do a task depending on first 5 chars in each line of a file. This script does not work (it shows each word as a line)? for rec in `cat myfile` do echo $rec | cut -c1-5 done MYFILE looks like this ABCDEsome string of data FRED some string of data HARRYsome string of data

I have a tbale of 5548 rows = 445Mb This table has over 1000 extents. If I reorder it, what would be best Initial, Next extent allocations (currently 104K , 128K)

I clone a database by shutting down A and doing a full *.dbf copy to another instance B on another server. I then recreate the B control file and start the instance. Now I want to put logging on instance A and not on B. Can I still do my clone this way by just specifying NOLOGGING on the B startup ?

Why does the free mem go down in vmstat ? kthr memory page faults cpu ----- ----------- ------------------------ ------------ ----------- r b avm fre re pi po fr sr cy in sy cs us sy id wa 1 1 46283 193717 0 0 0 0 0 0 298 1035...