Search Results

Search: Posts Made By: vasuvv
1,781
Posted By vasuvv
This issue am able to resolve it. But would like...
This issue am able to resolve it. But would like to write shell script to load the data from XML files to Oracle. We are going to use SQL Loaded with UNIX. Please suggest me the sample code to load...
1,781
Posted By vasuvv
We have no access to create Directory. So we...
We have no access to create Directory. So we can't use SQL Loader in Oracle side.


As the FILE3 is very big we are getting error as below


at <?xml version="1.0" encoding="UTF-8"?>


...
1,781
Posted By vasuvv
Experts, please advise. As we don't have...
Experts,


please advise. As we don't have any directory in Oracle we need to create a directory in Unix and need to load XML files to oracle table using Shell script.


Please suggest.

...
1,781
Posted By vasuvv
appreciate your quick response. I have around...
appreciate your quick response. I have around 10000 xml files with different contents/tags/column values. Please advise a script to automate /direct load data into Oracle tables.


Here in the...
1,781
Posted By vasuvv
Script to load XML file to Oracle table
Experts.

I have created a oracle table as below.


create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);



Daily we are receiving many...
733
Posted By vasuvv
Don, Please find below for Robin's queries ...
Don,

Please find below for Robin's queries

What have you tried so far?
--Have posted the code which will to connect to Database or not.
What output/errors do you get?
-- Was not able to...
733
Posted By vasuvv
Experts, It would be great if someone can...
Experts,

It would be great if someone can advise..

Thanks,
Vas
733
Posted By vasuvv
Robin, After reviewing many threads Here I...
Robin,

After reviewing many threads Here I have written the script to connect to database. With this I can see am able to connect to Datase by giving my credentilas.

#!/bin/ksh
sqlplus -s...
733
Posted By vasuvv
Shell Script to validate the access for Servers
Hi Experts,

Please advise to Write a Shell script,


To check , whether the user has access to UNIX PRODUCTION server or not?
If no, then need to provide the access to UNIX PRODUCTION...
706
Posted By vasuvv
There is difference in the files as the size of...
There is difference in the files as the size of the files as are below.
FILE1.txt 156665

FILES2.txt 154359
But its not displaying the differences. Please advise how to get the differences and...
706
Posted By vasuvv
Here , where can we find the output? I gave the...
Here , where can we find the output? I gave the grep -vf file1.txt file2.txt. then in 3 minutes(approx) its showing the $ prompt again. Please advise where can i find the comparison results.
...
706
Posted By vasuvv
By following the forum have copied the below...
By following the forum have copied the below code.
below code displaying result. But I would like to mail the differences as attachment which can be easy to understand for any user. ( I didnt add...
706
Posted By vasuvv
Shell Script to Compare Files and Email the differences
Hi,

I have 2 files abc.txt and bdc.txt.

I am using

$diff -y abc.txt bcd.txt -- compared the files side by side


I would like to write a Shell Script to cmpare the files side by side...
443
Posted By vasuvv
Automation Script for Oracle
Hi,

As a Oracle Developer, I am writing many Procedures,Functions and Packages. Facing Many optimization issue after writing these Database objects. Trying to tune it manually.
Can we write any...
1,384
Posted By vasuvv
for cron part , I have created Oracle Scheduled...
for cron part , I have created Oracle Scheduled job. So now can you please advise the changes in the remaining script.
1,384
Posted By vasuvv
What operating system are you using? LINUX ...
What operating system are you using? LINUX

What errors are you getting when you run the code shown in post #18?
not getting any errors but Unable to send Mail with attachement and unable to...
1,384
Posted By vasuvv
#!/bin/ksh to = "test@gmail.com" from =...
#!/bin/ksh


to = "test@gmail.com"
from = "robin@gmail.com"
subject= "mesg is mailing"


DB_DECRYPTED_PASSWORD='xyts'; --Need advise to hide the password...
582
Posted By vasuvv
Shell Script to run in given time
Hi All,

Would like to write a Script which will run between 11am to 3 pm and send the results to output.txt.

Please suggest.
1,384
Posted By vasuvv
Can you guide me how to schedule the script which...
Can you guide me how to schedule the script which will run between 12 to 3:30?

then only it has to count the data from the file.. please advise.
1,384
Posted By vasuvv
As the the query is going to run for every 15...
As the the query is going to run for every 15 mins, I would like to create a backup file and would like to name it as "EMP_FILE_bkp.txt"

For this it has to read the data from "EMP_FILE.txt" and...
1,384
Posted By vasuvv
please find below code which am running and Error...
please find below code which am running and Error message and advise.


FILE="scripts/EMP_FILE.txt"
#FILE="EMP_FILE.$(date +%F_%R).txt"
#touch $FILE

echo $ORACLE_HOME/bin/sqlplus
echo...
1,384
Posted By vasuvv
Bakunin, Here confused with giving FILE1 and...
Bakunin,

Here confused with giving FILE1 and "File" can you help me with MAIL command, do we need to give FILE1 or FILE??? getting errors at mailing part too.. pleasr correct me posted code and...
1,384
Posted By vasuvv
Hi, The table is having data. But need to...
Hi,

The table is having data. But need to check for every 15 mins whether its having data or not. I have written the script as follow. But giving error invalid number of arguments/file is not...
1,384
Posted By vasuvv
Shell Script
Hi All,

I am newbie to Unix and Shell script. Can you please help me to write a script.

Below is my requirement.

1.Send in email every 15 minutes from 12 to 3:30 PM. E-mail should only be...
945
Posted By vasuvv
Suggestion in Autosys job
Hi,

I am new to Unix and Autosys. I have written Oracle query. Now I would like to create Autosys job. below is the requirement.


Send in email every 30 minutes from 11 to 4:00 PM. E-mail...
Showing results 1 to 25 of 35

 

Featured Tech Videos

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