Search Results

Hi,

Sorry its not working..

Thanks,
Rajan

Hi,

I have a sql file that runs something like this

vi Test.sql

REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM PUBLIC;

REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM DEMO_READ;

REVOKE SELECT ON...

sed 's/TEMPORARY TABLESPACE [^ ]* /TEMPORARY TABLESPACE USERS /' 1.txt

Works perfect .. Thanks a lot....

Nope it doesnt seem to be working.

Sed is not able to identify the pattern at all when i use

/TEMPORARY TABLESPACE [^ ]+ /

Hi,

Here is my pattern

CREATE USER LZ
IDENTIFIED BY VALUES 'A0144280ESD70'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP1 PROFILE DEVELOPER_D_1
ACCOUNT UNLOCK
/

The Sed...

I think it works.. Thanks a lot for the tip.. Was really very useful...

Any Help....

Hi,

I have a Line input for awk as follows

DROP MATERIALIZED VIEW MCR.COMM_STACK;
CREATE MATERIALIZED VIEW "MCR"."COMM_STACK"
ON PREBUILT TABLE WITHOUT REDUCED PRECISION
USING INDEX...

Hi,

Yes you were right the below pretty much handles to what i exactly want

sed 's/D\:\\TOAD611\\/'I\:\\\\ToadControlFiles\\\\${ENV}\\\\${SID}\\\\'/g'

Thanks and kind regards,
Rajan

Hi,

I have a file with the following contents

# Lines that start with a # are comments.
#
# Calling TOAD like this will perform a comparison from command line :
#
# "C:\Program...

Hi,

The above exec command worked.. Thanks...

What are the commands if we would like to see the output on stdout as well as log to file. Because in case of exec the output is not being shown...

Hi,

I am running a shell script called dbProcess.sh which performs shutdown and startup of various Oracle instances we have.At the time of execution the script produces the following output to...

Hi,

I was able to get this working using the perl code below

#!/usr/bin/perl

$file = @ARGV[0];
open FILE, "<$file";
$file_contents = do { local $/; <FILE> };
if ($file_contents =~...

Hi,

Just wanted to check if anyone could help me resolve this issue.

Thanks and Kind Regards,
Rajan

Hi,

I am unable to get to delete/print lines using the
getLinesBetweenStringContainPattern function.

The sed '$!N;/ALTER.*\n.*MOVE/,/));/d' TestFile fails if there are two continuous Alter...

Hi,

I am new to package concept in shell script could you quickly help me out how to use the subroutines.I am running these shell scripts on K shell.

Thanks,
Rajan

Hi,

From the pattern mentioned below remove lines based on pattern range.

Conditions

1 Look For all lines starting with ALTER TABLE and Ending with ; and contains the word MOVE.I wanto to...

Any responses please i am really stuck with this for a long time and in a fatal need of a resolution to this issue.

Thanks a ton in advance,

Thanks and kind regards,
Rajan

Hi,

Nope not quite this one is just removing the ALTER TABLE and ; lines from the pattern and displying this rest.

Sorry for the dup post but i have the problem complete description on this...

Hi,

From the sample file below

Conditions

1) Pattern Range must start with "ALTER TABLE"
2) Pattern Range ends when it finds ";"
3) Between this range i want to select all the patterns...

One last question. Is there a way to print the lines excluding the pattern from the above example.

Works Perfect Thanks Chris And Frank....

Getting an error on this one too

$ sed -n -e '/ALTER TABLE/{N;/MOVE/!d}' -e '/ALTER TABLE/,/)\;/p' TestFile
sed: command garbled: /ALTER TABLE/{N;/MOVE/!d}

Hi Chris,

Its giving me the below error

$sed -n '/ALTER TABLE/{N;/MOVE/!d};/ALTER TABLE/,/)\;/{p}' TestFile1
sed: command garbled: /ALTER TABLE/{N;/MOVE/!d};/ALTER TABLE/,/)\;/{p}

Thanks,...

Hi,

Here is a sample of my Test File

$ cat TestFile1

Prompt Table DQZ_ALTER_SCHEMA_ID;
ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID MONITORING;
ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID STORAGE ( NEXT...