Search Results

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......

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...

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 ??

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...

No the above dont seem to work.. Please suggest something else

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...

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!

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....

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...

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...

Hi,

I tried that approach, it doesnt seem to work.. is there any other way. I am using Korn shell btw.

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!

Cero, Thanks a lot. That helped. i now grep the file to check for errors and take necessary actions from there. Thanks again!

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...

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.
...