Search results for query: *

Hi all, I would like to print all lines in a file based on conditions on nth field. Example below: Here I would like to print all lines in which 6th field has (cat or dog or bat or rat) and does not have (mat or pat). File: abc def ghi jkl mno cat_dog_bat_rat abc def ghi jkl mno cat_dog_bat...

Hi all, I am trying to join words to their previous line based on a condition. If a line begins with a word that does not begin with "USAGE", then it should join to previous line. I am showing as example below. Please let me know if we can we do it with a script. Thanks for your help in advance...

Hello all, I have a file with many lines like below and several other small lines in it. For all lines that begin with CREATE DATABASE LINK I have to replace <PWD> (i.e field 10) with <field 7>_ppp . field7 is not constant and it varies from one line to other. It needs to be dynamically...

Hello members, I have a text file and I am looking for a way to duplicate lines in it. Above every line, a duplicate line should be inserted with comment in the front as shown below. Any help will be appreciated. Can a sed or awk command do the trick. Thank you in advance. x y z --x x --y y --z z

I tested the script.. Its is just deleting the line with &&user. Need an alternative idea. Thanks all!

Hi members, I am trying to replace all strings that begin with &&user to user in the directory. It should replace in all files and sub directories of the directory. I've tried this but it doesn't work. I am using solaris 5.10 ksh and sed -i also won't work. find ./ -type f -exec sed -i...

Hi members, I need to set up an alias on Apache HTTP Server so that when someone accesses https://server1.domain.com they will automatically get redirected to https://server2.domain.com We are trying to take server1 off completely and we would like to redirect users who still use the old link...

Hello members, In order to copy data from one table to another via dblink, using insert into select * from syntax, what are the limitations in doing that? Is it a slow approach? Thanks in advance.

Hello members, What is the difference between creating an Oracle 10 database and export importing all schemas from another db into it versus a full import? We are concerned about losing privileges on sys objects etc when a schema level import is done. What are the prerequisites before doing a...

Hi members, In 10g database the tablespaces were created as assm (auto segment space management). The segment advisor is now recommending that some segments be "shrinked". What are the pros and cons of shrinking? Will there be an overhead should it require more space all of a sudden? Thank you.

Hi!! Can someone look into it?

Hi members, I am trying to convert a unix shell script to dos. It needs to delete all .test files in a directory and write to log file that the command was successful. When there are no files, it should write "no files available" to the logfile. I have this right now: SET DIR=C: SET...

Hi members. Greetings! I am looking for some info on tape drives. Can someone tell how can I check the available tape drives on windows 2003 server? Do I need a 3rd party software or can I check it internally in windows? Also, any documentation that you think will help will be appreciated...

Thanks I am already giving you points but can we also insert a line i.e. it will be a new line with / in it.

Hello, I would like to insert a line with symbol / before every occurence of SELECT (line) in a file. Any idea how that can bee done? Thanks.

Thank you. I have been told that since that is is a very old database the invalid objects are not of major concern. Thanks for your time and advise.

Santa, Thanks for asking these. Here are the answers. How many tables, consuming how much space are needing migration to 10g? Answer: This was a no-data import from a no data export dump file. The export file itself is only 8MB. Do you have access to intermediate versions of Oracle...

Hi, I am aware of the desupport of oracle 7.3.3.5 to 10g but will a full=y import ever work from 7.3.3.5 to 10g? I tried to do it, it worked but there are invalid objects. I tried many ways to compile them but they are still invalid.

Thanks PHV. awk '$2==$var {print $2}' /path/to/input I also used cat /path/to/input | awk 'match($2,"$var") == 0 {print $2}'` They are not working for some reason. Any ideas please. Thanks again.

Hi, I have added new databases to tnsnames.ora but they are not seen in enterprise manager, how can I refresh the enterprise manager 9i db console with latest tnsnames.ora file? I am using the 'logging to oracle management server option'. I tried to discover nodes but that didn't work. In...