HI guna, Â 1. the diff in grep and pgrep is grep show all the argument that you grep in your ourput. and pgrep only show the process no of the process. 2. yes...
Monzur, Thans a lot for the reply. :-) Thanks Guna ________________________________ From: monzur monzur <mon_som_31@...> To: oracleclub@yahoogroups.com ...
hi All, Kindly suggest me which book is better for oracle DBA,that will be easy and given in a step by step process.I already have a knowledge of SQL/PLSQL. ...
Hi All, I just wanted to know how to recover UNDO tablespace when a datafile of UNDO tablespace is lost while the database is online. More over is it required...
Dear Guna, Â First of all you dont need to recover the UNDO tablespace. since the database is on, then create another undo tablespace and change the default...
Babu, Yes i got it. Initially i was thinking i need backup of UNDO tablespace also but from all the responses it is clear that backup of UNDO tablespace is not...
Dear Guna, Â You can follow this was also.. Â 01. create another tablespace (ex named undotbs2) 02. alter system set undo_tablespace=undotbs2 03. drop first...
What's your OS Version? Please provide your Patch Nr Details. -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From:...
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....
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...
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'...
Hello, Where is details? -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From: Yahoo! Groups Notification...
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 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...
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...
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 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 ...
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 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...
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...
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....
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...
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.
