Thank you very much...diana... Martin Andrews T ________________________________ From: diana deaconu <dde_diana@...> To: oracleclub@yahoogroups.com Sent:...
Hi Martin, You have scripts for the automatically created tables like misrep010109, misrep020109, .......... Include a create trigger in that scripts. That...
Hello, Martin! Here is my solution for you problem. As you cannot touch the application which is anutomatically creating the tables MISREPddmmyy, you cannot...
I'm a little bit confused :) How many triggers do you want to have: a. a trigger for each tableMISREPDDMMYY tables that are created automatically b. just a...
Hello! If I understood well, your script/application is inserting data into multiple tables, there names being like MISREP% and you want a trigger to handle...
hi, CREATE OR REPLACE TRIGGER add_MIS BEFORE INSERT ON MISREP FOR EACH ROW declare . . . . end add_mis This is normal trigger... add_mis is trigger name. ...
hi, if we create a trigger like this CREATE OR REPLACE TRIGGER add_MIS BEFORE INSERT ON MISREP FOR EACH ROW declare . . . . end add_mis here table_name is...
Hello all, Â I faced some problem in my project my project is on DOT NET AND SQL SERVER we use BE/MBA/MCA like this line we want to do that if any one search...
Thank you very much. I didn't think about it at all. I was think about recovering the entire database using the backup from old server including controlfile....
Great....thats good you have the old one. check the old server that the datafiles are also corrupted or not ? if not ...shutdown the database and copy these...
Hi All, Â Â Â Hope everyone are doing good. We have a problem with block corruption. We have a QA box running Oracle 9i in RHEL 3. Our sys admin guys clonned...
Hello Pura, Thanks for sharing with us. One question to you; Have you tried this one? Using one/two way replication/steams?? If yes let us know what's the...
Hi Friends, Good Evening, I need help on setup Oracle Streams to know exactly, how do we setup like below Table A (source) ID Date Description Credit Card ...
Dear/ All   In Oracle Application R12 what is the (API) to upload Ex-Employees (for Employees termination)  I have an Excel sheet with employees (Emp_No,...
Hi All, We have 5 instances running in Oracle 8i and we are planning to migrate 4 out 5 instances to Oracle 10g R2. The reason we are not migrating 1 database...
Hello Taj , I have this trigger CREATE OR REPLACE TRIGGER test_inter AFTER INSERT on test_internet for each row declare v_username varchar2(15); begin SELECT...
Yes. http://tahiti.oracle.com/ Check here as per your database version -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ...
Hello, Where is details? -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From: Yahoo! Groups Notification...
Hi Friends, I am upgrading from 9.2.0.4 to 9.2.0.8 While running catpatch.sql below error occurs create type XMLTypePI OID '0000000000000000000 000000002014F'...
Thanks Babu for your reply and help. If you know about it or how i will be better for this. if you have any suggestion then reply me. always welcome your...
Hello Everyone, Â Hows life treating to u all. Hope so everyone doing well. Â I have 2 topics to make a RESEARCH PAPER Â 1. Data privacy and setting 2....
What's your OS Version? Please provide your Patch Nr Details. -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From:...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
