Search Results

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

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


...

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.

...

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

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

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

Experts,

It would be great if someone can advise..

Thanks,
Vas

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

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

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

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

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

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

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

for cron part , I have created Oracle Scheduled job. So now can you please advise the changes in the remaining script.

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

#!/bin/ksh


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


DB_DECRYPTED_PASSWORD='xyts'; --Need advise to hide the password...

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.

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.

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

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

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

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

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

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