Hi All, I face a problem with my temporary tablespace. After I drop my temporary tablespace from OEM and even through SQL*PLUS using the command "DROP...
post your error details -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From: guna dev <guna_dev@...> Subject:...
Babu, i didnt get any error. The actual problem was we had 2 partitions for oracle /oradata and /orasoft. We had a temporary tablespace temp containing 2 temp...
Hi , Amazon Development centre hyderabad is hiring for Senior Oracle DBA with experience of 5+ Yrs who would like to work as Individual Contributor .Please...
hi, I am sudhansu,presently i am working on sql/plsql and now i want to switch from plsql to dba ,will it be a wise decission.Or which technology will be...
Hi All, Â Â Â Â Â Â Hope everyone is doing good. I want help from you all. I need answers for these questions. 1. What is the difference between grep and...
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...