Hi All,
    I am working on Oracle 11.2.0.3. and my requirement is,
    I have a table in Development(Dev)  called " Dev_EMP".  
    Have created Synosym for "Dev_EMP" as  "SY_DEV_EMP"

    here is the structure 
    [/code]
    create table Local_emp
    (
      tran_id  varchar2(10),
      acct_id  varchar2(15)
    );
    [/code]

    2. Table which I am planning to access from Production is as below.

    create table c_emp
    (
      tran_id  varchar2(10),
    ex_ind  varchar2(20),
    f_id      varchar2(20)
    emp_stud  clob
    );
    [/code]

    Now the requirement is 

    would like copy  "ex_ind","f_id" columns from PROD to DEV table i.e"Dev_EMP" alias  "SY_DEV_EMP" and load the data to these columns data from Production table "c_emp" to Dev Table. 

    /*I gave the ALTER statement as below to add columns.

    ALTER TABLE Dev_EMP ADD ex_ind VARCHAR2(20) ;
    ALTER TABLE Dev_EMP ADD f_id VARCHAR2(20) ;

     INSERT INTO Dev_EMP(ex_ind,f_id)
       select ex_ind,f_id from c_emp@DL1;*/

    ERROR : TABLE OR VIEW DOES NOT ESIXT.-- But have alreadt created the table and Synonym also created. but getting this error. Advise how to write ALTER.

    3. advise query/procedure to load data from PROD to DEV table.

Thanks

I didn't not write any procedure. Can you please advise any stored procdure to satisfy the above requirement. I have written the query as follows to get the information. But didn't get the complete required information.

SELECT * FROM ALL_source WHERE UPPER(text) LIKE '%BLAH%'
AND TYPE='PROCEDURE'
AND OWNER='XXXX';

Hi,

I am currently working on Oracle 11.2.0.3. Below is my requirement.

1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement.
( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements.

  1. Need to take the list of those objects ( having the DROP statements). (in Excel/CSV)

  2. Then need to drop only those objects from the schema.

Can any one please advise.

Thanks,
Vas

Hi,

Thanks for your response. I am interested to develop in Android. Could you please let me know what are the tools are required and how to start a program for this. Can you please give me some idea because this is my first attempt to develop these king of stuff.

Thanks.

Hi all,
I am planning to design mibile app using c,c++ if possible.can any one please suggest me how to design it if possible.
Please your thoughts regarding this and appreciate your suggestions.

Thanks,
Va.

On windoes plat form I am planning to build the app. So please have a look and suggest me regarding the same. Thanks all for your replies.

Hi,

I would like to build a mobile appliations to find out the locations of the hospitals lists all over the state ( distrcit wise) in my mobile. Could you please suggest How can I develop mobile app for the above requirement.

Thanks,
Vas.

Thank you very much.. Will start working on it.

I have knowledge on HTML. I will go throgh the W3School site to design and develop a tool which meets my requirement.

My intention is to get good knowledge in Frontend as well. So Please share your thoughts on this.

Thanks.

Hi,
Thank you very much for your qucik response. Before starting this task , am newbie to this webdesign. Am a Oracle Database developer.

For small kind of stuff could you please explain me I want to design a tool/website like :

In our office, each and every one they should update the tasks what they are worked on every day and they hould submit ( required buttons need to be created.). EOD of every week it should generate a report and send it to our Project Manager. So as per the report he will review each and every ones work.

If people want to save any file that should be save d in some specific folder.

for this requirement How to design a page please explain me. Then I will design a webpage.

So please let me know what are the fields are required and add your views as well.. Appreciate your help.

Thanks.

Hi All,

Could you Please give me your valuable suggestions for the following requirement. I am not sure whether this is the right place to post this thread but please have a look and give me your suggestions.

  1. I am planning to design a ticket tracking tool.
  2. If any issue comes /any job got failed the related mail first it should go to the Helpdesk team and they will assign this ticket to the respective team. that Mail with ticket number will go to the whole team.
    but the respective person will take the ownership of the ticket he/she will start working on it.
  3. once the issue is resolved he should update the status and the Root cause of the issue and the solution of the issue.
  4. He should prepare the solution document and should upload it in the tool and some where (but he should mention the path).
  5. Once everything is done it should calculate how many incidents got raised and how many issues got resolved/pending/waiting for Customer Input kind of stuff should be generated as a report by the end of every week and should send a mail to the whole team.

so that it is easy to trace out the number of incidents raised ? and Number of tickets resolved/pending/waiting for customer input.

Please let me know for the whole process how to develop a tool? Please let me know the process. Then I will try to design a tool for the ...

Hi All,

We are planning to write automation script to install oracle. Can you please let us know is it possiblw to
write any script for the above requirement,if yes please share your thoughts.

Thanks,
Vas.

Hi,

Some jobs got scheduled.let us take an example of 5 jobs. first 4 jobs got scheduled in one server(assume it as A).last jobs got scheduled in another server(assume it as B).so the requirement here is once the 4 jobs got completed in server A, then we need to connect to the second server and need check for the file which is located in the given path.Go to that particular file and double click, then it will show you the job gt completed.

Then again we need to connect to the first server A and go to the 5th job and right click and click on Confirm button. once it's completed successfully it should mail to the distributed mail list.

Here what we need to observe is -- if the job got completed it will show ypou the Green else red color.

For this requirement we need to write automation script.Please let me know is it possible to write a script? if yes please suggest me the code.

Thanks,
Vas.

Hi all,

Thank you very much for all your suggestions.So please let me know which is best to write a program for the above requirement.The docs should be secured.

So please suggest me.

Thanks,
Vasu

Hi,

By using href we can give hyerlinks to required docs in HTML but it is not that much secured so I want to write a program for the above requirement using XML.So please help me out in this.

Thanks.
vasu

Hi,

Thanks for your reply and could you please suggest me how to write a program using XML hope it would be fully secured to using the docs. so please suggest me how to write a program for this and am not yet used XML. so please guide me to write a program for the above requirement.

Thanks,
Vasu.

Hi,

I am new to HTML kind of stuff. I have some documents in my own folders for different applications. I want keep all the documents in related Hyperlink under that particular department. after creating all the hypertlinks that link link should navigate to that particular document.

once it is done i need to keep all the docs related Hyperlinks in my own website which is developed by Java application. so can any one guide me to write the program for this requirement.

Please let me know if you need any other information.

eg: I have applications called ABC,DEF,GHI under ABC i have 5 documents. so want to create hyperlinks for all those docs.like that i want to create for all.IF any time I want to take particular document directly i want to click or search for that particular doc with some keyword it should directly navigate to that particular document and it will open it.

Kindly help me to resolve this issue.

Thanks,
Vasu.

Hi,

we have some scheduled jobs.The jobs will truncate the data and inserting the data and update the data.This process will happen daily. we receive files like truncate_file,Insert_file and update_file to our INBOX in scheduled time.once we got the update_file we will connect to front end application by using user_id and password. Then we have some rules.we will start running those rules. once the status shows "completed" then we will again goto mailbox and then send a mail to distributed mail list as " Monday data loaded successfully" ( if it is monday) this will happen daily.we are doing all these process manually.

But please suggest me is there any possibility to write a script for the above mentioned process.if it is Monday then monday else the name of the day.

if the update_file is not yet arrived it should wait for 20 mins then it will send a mail like " the job got failed " message to the mail box.

please help me out to write a script for this.Please let me know if you need more information.

Thanks,
Vasu.

Hi,

we have some scheduled jobs.The jobs will truncate the data and inserting the data and update the data.This process will happen daily. we receive files like truncate_file,Insert_file and update_file to our INBOX in scheduled time.once we got the update_file we will connect to front end application by using user_id and password. Then we have some rules.we will start running those rules. once the status shows "completed" then we will again goto mailbox and then send a mail to distributed mail list as " Monday data loaded successfully" ( if it is monday) this will happen daily.we are doing all these process manually.

But please suggest me is there any possibility to write a script for the above mentioned process.if it is Monday then monday else the name of the day.

if the update_file is not yet arrived it should wait for 20 mins then it will send a mail like " the job got failed " message to the mail box.

please help me out to write a script for this.Please let me know if you need more information.

Thanks,
Vasu.

Hi All,

We are using one application. This application is having 2types of jobs. Under each job again there are each 5 sub jobs. All the jobs are scheduled jobs. Now the requirement is
The main 2 jobs we are going to run on some specified days( for this we need to mention on what days we want to run.once we gave those day the next steps will start).
for example 1 main job is scheduled on Monday ( we need to schedule it on monday-- we need to write a program for this) under this every sub job will run.these sub jobs are dependent jobs.if sub job completed successfully it should send an email to the distributed mail group which says like " <Job_name> completed successfully" if it fails also it needs to send an email to the distributed group. for each sub job it should send either success/falure mail to the distriuted mail group.

once after completing all the sub jobs successfully it should send a mail to the distributed mail group saying that The main job got completed successfully.

these two main jobs will run paralelly but the the second main job will run after 30 mins of 1st job starts.

in the second job also will work as same as job1 process.it should also send mails to the distributed mail groups.

Please guide me how to write a pl/sql program well tuned program.

Thanks in advance.

Hi,

I am not aware where to post my query.That's why here I am posting my query.I am sorry for my mistake.

Here the requirement is s to write small JYTHON script to modify some parameters on a WebSphere cluster at install time.

I am new to this concept. SO need your help in coding.Please help me out in this.

Thanks in advance.

Hi,

we are having some scheduled jobs.If these jobs runs successfully the files will be arrived into the some specified folder.But some times I am unable to find out the files are not yet arrived.

So now i want to write an automation script which will inform you like the files are not yet arrived (once it crosses the scheduled time).so please help me out to write an automation shell script for this requirement.

Thanks,
Vasu

Hi,

we have some scheduled jobs which will run parallely.want to send log files of those scheduled jobs for every 1 hour via email to the destination mail group.

have written one command in AS400 it is sending the log file as attachement.but the issue is if i open that attachment i am getting the job name only.But I need to get the complete log file of that job in that attachemnt.

So cna you please help me out to write a script for this .

Thanks.

Hi All,

I want to write an automation script, which will send log files of Scheduled jobs via email for every one hour.

Please help me out to write a script for this.

Thanks.

Hi,

Please let me kmow regarding Autoit scripting .

Thanks.

Hi All,

Please find the following requirement and let me know the possibilities if any.

We have some daily,weekly and monthly jobs which will run parallelly.we need to monitor the
jobs.there we have start time ,we need to find out the end time and need to paste it in excel sheet like

Time Job_name Start_Time End_Time Priority_of_the_job

in the above list we have everything in Excel sheet except End time.IS it posssible to write any script if the given job is completed it should copy the end_time directly into the excel sheet without manual work.

because rite now we are monitoring manually and we have to wait for the end time of the job if it is completed we need to copy the end_time and pasting it in excel sheet.

Please let me know if it is possible to do automaticcaly by the system.

Thanks in dvance.

Hi ,

I have a excel sheet.in that one column called hardcoded.
we have sheet as folllows.
Name EMp_ID Hardcoded

ABC 1987870 1. EMP_SAL_CD : "2000","1300","Avg100"

  1. DEPT_CD : "Manager","clerk","anlyst"
  2. DNAME : "SALES","HR"
    STU 1909890 1.EMP_SAL_CD : "6000","300","A100"
  3. DEPT_CD : "Manr","cle","ant"
  4. DNAME : "SALES","HR","STUD"

Now I want the O/P as follws

Name EMp_ID EMP_SAL_CD DEPT_CD DNAME

ABC 1987870 "2000","1300","Avg100" "Manager","clerk","anlyst" "SALES","HR"
STU 1909890 "6000","300","A100" "Manr","cle","ant" "SALES","HR","STUD"

Can any one please help me out to write a shell script for this issue.

Thanks,
Vasu

Hi,

Can you please find the following issue and give me your ideas.

I am using job scheduler tool Control-M.
My issue is, I have pl/sql objects called 'A','B','C','D'.

This tool contains some list of objects.

I found the objects 'A' and 'B' in the tool.if I click on the object in the tool i can find the Box name and the Job name for the objects.

But I am not able to find the objects 'C' and 'D' in the tool ).I want to find out the Box names and Job names for the objects 'C' and 'D' .

These 'C' and 'D' might be there inside the Box names.

Right now I doing manually searching for each and every object in the tool and finding out the Box names/job names for the missed objects.

Please suggest me is there any query/process to findout?

Thanks in advance.

Hi,

we have pl/sql objects.for some pl/sql objects we found the object names in the scheduler list to run it.But we didn't found the some objects to run the jobs.
the scheduler contains Object list. if you select one object and click on submit button then it will show u Boxname,Subbox name,Job name.
we are not able to find the object name.
Now we want to find out the object,taht may contain in some object (with some different name) in scheduler objects list and in that, any of the boxes may contain the required Object name.

now we are manually checking each and every object in the scheduler list to findout the exact object name.
Could you please suggest me if any other way is available.

Thanks,
Vasu.

Hi,

I have one Oracle standalone procedure.In this am doing truncating the data and loading the new data into the target table.
The issue is , I want to know whether the table is callable from other procedure,if it it callable I want to know the Procedure or Packages list.

and want to know the related child tables from the system table?

Is it possible to write any program for this? Please share your ideas...