Search results for query: *

This is probably a very basic question so apologies for asking. I'm cloning my live database. I have files from a hot backup (we don't use RMAN). I create a text copy of the control file, edit it accordingly & run it. I then get the reply "Control file created" which looks good. I can...

I'm curious to hear what people think about tbe best way to edit files automatically in a script. I'm making edits to a number of lines in a file (10+ lines need changing). It's straightforward editing which never varies so it's easy to do but what method would you use? The way I'm doing it...

I want to automatically edit the file produced from an Oracle database by running this: alter database backup controlfile to trace; so that I only get the first definition of the control file - i.e. the first part that begins STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "OUT_DATABASE"...

I want to copy a certain picture (photo) from one sheet to another depending on the value of a variable. So if the variable = 1 then I copy Picture 1 if it's 2 I copy Picture 2 etc. I have this to copy a hardcoded picture: Sub CopyOnePicture() Dim wsSource As Worksheet Dim wsDest As...

I want to run a script with a parameter & then pass the parameter to some sql code in the script. I've spent a long time looking on the web & none of the suggestions I can find works: Here's a simplified version of the script called test_sql: #!/bin/ksh ## ## ## set oracle variables up...

If a file is older than 6 months ls -l doesn't show the time it was accessed. I assume this information is still held against the file - is there any way I can get it? Thanks, Chris

Does anyone have any comments about using nice to decrease the priority of running sqlplus? I need to run a PL/SQL program which is quite processor intensive – I can run it at night when I won’t affect users but I’d like to run it during the day. I’ve tried using nice but my (very cursory)...

I have a file which consists of repeated field values on separate lines. I want to convert it so that the values are on the same line separated by a pipe char (& then a new line for each new record). e.g. my original file is 4 The Beatles Liverpool 5 The Rolling Stones London 3 The Who...

I'm stuck with the definition of the condition in a while loop. What I want to do is loop until a certain process has started. I can't easily test this directly because it requires restarting the machine so I'm testing by watching for any process which is owned by a certain user (so when I...

I'm new to Apache so I'll probably ask some naive questions here - apologies for that. We have a Windows system running Apache 1.3.33 & we need to upgrade it to 1.3.41. Our suppliers have not tested their system with any newer version than that. They have advised me "This is not a clean...

I want to run the find command to grep all files except those that end with ".log" which have a certain string in. I understand there's a -not flag in Linux but I'm on Solaris & it doesn't seem to exist there. This works file on all files ($1 because it's in a script) find . -type f -print...

I'm getting back to doing some PL/SQL coding after a break of several years. I'm trying to start with something simple & building on that. create or replace procedure change_details( dirname in varchar2, id_filename in varchar2) is ids_file...

What's the syntax to insert a non-printing char (e.g. octal 012) into a string? I've tried things like: # date Wednesday June 25 14:17:22 BST 2008 # date | sed 's/BST/\012/' Wednesday June 25 14:17:47 012 2008 # but whatever I try it doesn't substitute to the single ascii character (this...

I have a system where a file is ftp'd to our server by one user (ID=ftp_user; group=staff - for the sake of illustration). I want another user (ID=my_user; group=my_group) to run a script in cron which looks for the file & when it arrives, to move it to another area. User my_user can't move it...

I'm sure this is a very elementary question but Im struggling to find the answer probably because I'm not familiar with the terms. (I'm fairly new to VB). I'm writing a macro in Excel. I'm working down a column & moving the value in a cell to a cell in a different column. Once I've moved the...

Hello I'm trying to create a rule such that when I receive a mail with a certain subject line the font is changed to courier. As I understand it I probably need to run a VB script to do this. When I go through the Rules wizard & get to "Run a script" I can't see any scripts to call. I...

Hi I have a file which came out of our application - the final line of this file *should* end with \r\f. Unfortunately I needed to edit the file (in vi) which puts an additional \n on the end of the file - so now it ends \r\f\n. My question is how can I remove the final \n. I know I could...

I remember reading an answer to this question a few years ago - I've searched but can't find it. If I want to grep the process list for a process I've just run I always get my grep process in the output. I can remove this by piping to grep -v grep but I know there's a more elegant solution...

I'm trying to install gcc on my Solaris 5.8 machine (with a view to installing mutt). I used this link which seemed very useful: http://gcc.gnu.org/ml/gcc/1999-08n/msg01022.html But when I try to compile a Hello World program I get this error "ld.so.1: gcc: fatal: libintl.so.3: open failed: No...

Hello - If I right click on a folder in Windows Explorer & select Properties it shows me Size & Size on Disk - not sure of the difference but either are good enough as an estimate of the amount of space used by files under my chosen folder. How can I report this figure at the command prompt? I...