The Sed command must look for the Line that contains TEMPORARY TABLESPACE and replace the immediate word (TEMP1 in this case) after pattern (TEMPORARY TABLESPACE in this case)
the above must be changed to
I am trying with the below sed commands
The above one removes the word PROFILE which is not desired. Also as in this case the 3rd word after pattern is TEMP1 is not consisten it could be any 4 / 5 / 10 letter word.
Hi All,
I have almost 1000+ files and I want to search specific pattern. Looking forwarded your input.
Search for: word1.word2 (Which procedure contain this word, I need procedure name in output.
Expected output:
procedure test1
procedure test2
procedure test3
procedure test4
... (7 Replies)
Hi All,
I am new to unix shell scripting, I need your help guys in coming up with some thing for the following scenario:
file1
ABC_BASE ${base}
ABC_ACC ${acc}
ABC_TEST ${test}
01-01-2006 ${from_dt}
01-15-2006 ${to_dt}
file 2
I have an file2.sql file which contains:
####This... (4 Replies)
hi guys,
insert into /*<new>*/abc_db.tbl_name
this is should be replaced to
insert into /*<new>*/${new}.tbl_name
it should use '.' as delimiter and replace
is there any way to do it using sed (6 Replies)
i have a file like below. how can i printout the digits followed by the pattern -bwout and -bwin. say i run the script by entering line number 145 (the fourth line), then the o/p should be like
5000000 1024000
8 test1 -ipprot erp -ppsout 500 -ppsin 500 -bwout 300000 -bwin 300000 -statsdevice... (7 Replies)
I need this.
aaa
OOOOO
bbb
ccc
OOOOO
ddd
fff
ggg
OOOOO
iii
OOOOO
I need all OOOOO replaced with PPPPP, but only change after the pattern ggg. So the first two OOOOO should not be changed.
OUTPUT should be :-
aaa (2 Replies)
I have a pattern
username:x:32005:32006::/usr/local/user:/bin/bash
I need to match the line containing username and replace /bin/bash with /usr/local/my/bin/noshell
So it becomes
username:x:32005:32006::/usr/local/user:/usr/local/my/bin/noshell (7 Replies)
I have a file containing a multiple lines of the format
sddfdsf_gaf/ywrtrtwrt_gaf
ghfghfgh_ert/xcvxcvcv_ert
werwerwwerw_adf/jkhjkhjkjhkjhk_adf
I am interested in only the first 3 letters following the "_" character and make those 3 letters uppercase after extraction. So would like to convert... (5 Replies)
Im using the command below , but thats not the output that i want. it only prints the odd and even numbers.
awk '{if(NR%2){print $0 > "1"}else{print $0 > "2"}}'
Im hoping for something like this
file1:
Text hi this is just a test
text1 text2 text3 text4 text5 text6
Text hi... (2 Replies)
This command is not working for me.
awk '{if ($1 == server) {$1 = #server} }' /etc/ntp.conf
# grep server /etc/ntp.conf
# Use public servers from the pool.ntp.org project.
server 0.rhel.pool.ntp.org iburst
server 1.rhel.pool.ntp.org iburst
server 2.rhel.pool.ntp.org iburst
server... (5 Replies)
Hi Guys ,
I am having a file as stated below
File 1
sa0 -- i_core/i_core_apb/i_afe0_controller/U261/A
sa0 -- i_core/i_core_apb/i_afe0_controller/U265/Z
sa1 -- i_core/i_core_apb/i_afe0_controller/U265/A
sa1 -- i_core/i_core_apb/i_afe0_controller/U268/Z
sa1 -- ... (7 Replies)
Discussion started by: kshitij
7 Replies
LEARN ABOUT CENTOS
alter_tablespace
ALTER TABLESPACE(7) PostgreSQL 9.2.7 Documentation ALTER TABLESPACE(7)NAME
ALTER_TABLESPACE - change the definition of a tablespace
SYNOPSIS
ALTER TABLESPACE name RENAME TO new_name
ALTER TABLESPACE name OWNER TO new_owner
ALTER TABLESPACE name SET ( tablespace_option = value [, ... ] )
ALTER TABLESPACE name RESET ( tablespace_option [, ... ] )
DESCRIPTION
ALTER TABLESPACE changes the definition of a tablespace.
You must own the tablespace to use ALTER TABLESPACE. To alter the owner, you must also be a direct or indirect member of the new owning
role. (Note that superusers have these privileges automatically.)
PARAMETERS
name
The name of an existing tablespace.
new_name
The new name of the tablespace. The new name cannot begin with pg_, as such names are reserved for system tablespaces.
new_owner
The new owner of the tablespace.
tablespace_parameter
A tablespace parameter to be set or reset. Currently, the only available parameters are seq_page_cost and random_page_cost. Setting
either value for a particular tablespace will override the planner's usual estimate of the cost of reading pages from tables in that
tablespace, as established by the configuration parameters of the same name (see seq_page_cost, random_page_cost). This may be useful
if one tablespace is located on a disk which is faster or slower than the remainder of the I/O subsystem.
EXAMPLES
Rename tablespace index_space to fast_raid:
ALTER TABLESPACE index_space RENAME TO fast_raid;
Change the owner of tablespace index_space:
ALTER TABLESPACE index_space OWNER TO mary;
COMPATIBILITY
There is no ALTER TABLESPACE statement in the SQL standard.
SEE ALSO
CREATE TABLESPACE (CREATE_TABLESPACE(7)), DROP TABLESPACE (DROP_TABLESPACE(7))
PostgreSQL 9.2.7 2014-02-17 ALTER TABLESPACE(7)