Search Results

Search: Posts Made By: qwertyu
1,324
Posted By qwertyu
extract string from another string
i do not require to replace that with "Replaced". i want to take out that string - "Replace_12123_31233_32134_12342" and do certain operations with it... this might be a different string everytime......
1,324
Posted By qwertyu
Extract a string from another string in UNIX
I have a string

string="Please have a nice day and sleep well Replace_12123_31233_32134_12342 Good day"

How do i replace "Replace_12123_31233_32134_1234" in the above string.??

Please...
7,087
Posted By qwertyu
Setting permissions :
If it were a compressed file already, then why is the "compression" option available where we can specify metadata_only, data_only, all or none ??
7,087
Posted By qwertyu
Changing file permissions of a file created by another user
Hi,

I have used expdp for datapump. The .dmp file is created by the "oracle" user.
my requirement is to make a zipped file of this .dmp file.

What i am trying to do is change the permissions...
19,610
Posted By qwertyu
No the above dont seem to work.. Please suggest...
No the above dont seem to work.. Please suggest something else
19,610
Posted By qwertyu
Zip dump file using expdp:
Hi All,
i am using expdp to create a dump file of contents from an oracle table. I want this dump file to be zipped. Is there a way/ option in expdp where the dump file will be automatically zipped...
9,801
Posted By qwertyu
Yes. This is what i finally tried and it worked....
Yes. This is what i finally tried and it worked. But increase the size suiting your heading size. Mine was around 14 so i kept is as a15..

Thanks Bipinajith!
9,801
Posted By qwertyu
Format options while Redirecting output of sql to a file in shell
Bipinajith,

If i do that all the column headers are printed fully but the formatting between the column headers and the data is lost. The data doesnt fall correctly under the corresponding header....
9,801
Posted By qwertyu
Format options while Redirecting output of sql to a file in shell
Ok ill keep that in mind next time to use these code tags.

Please find my code here -


sqlplus -s / >$my_file <<EOF
set serveroutput on;
set pagesize 400;
set heading on;
set...
9,801
Posted By qwertyu
Format options while Redirecting output of sql to a file in shell
In my korn shell - I have a sql with say 6 columns whose output i am redirecting to a file and attaching this file while sending a mail. While all this happens correctly, i face issues in the...
2,521
Posted By qwertyu
setting environment variables from file
Hi,

I tried that approach, it doesnt seem to work.. is there any other way. I am using Korn shell btw.
2,521
Posted By qwertyu
Setting environment variables from a file :
Hi,

I have around 10 environment variables in my shell script. i want to set this all in a file and just call that file in my shell script. How can i do that ? Please help. TIA!
10,121
Posted By qwertyu
expdp error logging
Cero, Thanks a lot. That helped. i now grep the file to check for errors and take necessary actions from there. Thanks again!
10,121
Posted By qwertyu
Expdp error logging:
i am using expdp in korn shell to export tables from oracle. What i dont know is how to capture any errors if my expdp fails.
I am looking for some options like Spool where i can write the error...
47,594
Posted By qwertyu
Mailx command - send mail as table format
I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong.
...
Showing results 1 to 15 of 15

 
All times are GMT -4. The time now is 01:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy