Recent content by ErrolDC

Chacalinc's suggestion worked for me. I did %s\t because I needed some sort of space to substitute for the newline Thanks everyone

Is it possible to use the 'list' or 'report' commands in rman? When I do so, rman throws an error. oracle@mipt01 # cat rman.commands run { backup database; backup archivelog all delete input; crosscheck archivelog all; crosscheck backup; restore database validate; restore archivelog all...

Sure. The is a list of oracle instances. One instance per line. I want to feed them into the korn shell so as to create an array. So, if the file looks like foo1 foo2 foo2 I need it reformated as: foo1 foo2 foo3 Thanks

sorry, what I meant was multi-line into single line output

Hi everyone. I want to read a file that consists of single line entries and output them as one line, space seperated. Text and file manipulation is not my best skill. Can someone point me in the right direction? Is AWK the tool I need? Any examples?

Hi folks. There is something I need to understand how to do properly and I was hoping to get some insight. Suppose I want to loop through an array. I am looking for specific text string. If the string is found, I want to stop searching the array and perform some other action. If it is not...

Is it necessary to apply SP3 to machines when you only install the MS SQL client libs?

When performing incremental backups with RMAN, how does RMAN determine which blocks have changed since the last backup? Is this reliant upon the actual backup peices or the metadata related to this stored in the recovery catalog or control file? Thanks.

Aha.. Thank you very much. Switched to udp.

Hi. I'm trying to figure out why my PIX stops routing traffic after a while when I have it logging to a syslog server. Here is my config.. Cisco PIX Firewall Version 6.3(1) Cisco PIX Device Manager Version 3.0(1) Compiled on Wed 19-Mar-03 11:49 by morlee DFIN-515E up 33 mins 58 secs...

With the Scripting.FileSystem object, one can check to see if a file actually exists before trying to open it. Is it possible to examine the registry for a particular keyname to see if it exists? Everything I've seen and done at this point assumes that the key exists. Thanks. Errol Neal

Thank you very much LKBrwnDBA. I really appreciate your help.

Does rman provide a way to backup a user's schema - much like exp? I know I can backup a tablespace, but that does not guarantee I get all of the user's objects that may exists in tablespaces outside of his/her default. Errol

It's not much. It's just a few lines. #!/sbin/sh date="date '+%Y%m%d'" HOME=/export/home/oracle ORACLE_SID=tkbpre; export ORACLE_SID echo "Exporting a copy of the mipttkb schema from tkbpre.." $ORACLE_HOME/bin/exp log=$HOME/logs/exp-mipttkb\"{$date}".txt parfile=$HOME/scripts/exp.par

Hi. For the life of me, I cannot seem to figure out how to pass the exp utility variables from within a script. The variables are not recognized by exp and are substituted with white space which makes exp complain about being supplied two values for a parameter. This is a *nix script so if...