Recent content by zircon06

Thanks Mufasa !! that will be solve my current situation

Hi all, Can anyone help me wiht command or query to get database size. Thanks

Hi santha or anyone, Can anyone throw your thoughs how to measure tables size growth when upgrading from database from one version to another this is into oracle version upgrade but just on database side let us say database version at 4.5 level and upgrading to 4.8 level. Thanks in advance

First thing check you did apply service pack on server. YOu can check by running select @@version

Anyone tell me how to jobs in Dev to QA in 2000 box Thanks

I have shell script with bunch of sql file need to each with pause for each file. Each bascially idea in this way @/u01/test/statement.sql pause Press RETURN to continue... @/u01/test/account.sql pause Press RETURN to continue... @/u01/testdetails.sql Anyone guide me to run these in...

Anyone point me syntax problem with this trigger CREATE OR REPLACE MPW_MSG_INSERT BEFORE INSERT ON MSG FOR EACH ROW BEGIN IF (:new.msg_message is like '%|B12|%') THEN (:new.msg_message := REPLACE(:new.msg_message,'|B12|','|B18|')); ELSE ( :new.msgdet_message is not like...

aynone tell me can oracle9i and oracle10g ear files hosted on single server Thanks

The oracle enterprise manager uses rman concepts to do backups of the database so if you setup em properly know to write script rman script. Actually you can preview the code of backup command in rm by selection view sql under backup screen of maintainence tab.

Hi gurus, Anyone walkthrough me steps creating RMAN DUPLICATE DATABASE From ASM to ASM environment. I have a database student using ASM if I want to create to duplicate database of student in same server what was steps to be followed. Thanks in advance

Make sure to different tcp port for another instance

UPDATE studentmaster SET active = 0 FROM studentdetail WHERE studentmaster .orderset_sys = studentdetail.orderset_sys AND order_text like '%continuation of class%'and class_ID= ' 400000' Thanks in advance

SQL Server 2000 Enterprise Ed. with /GB /PAE switches in the BOOT.INI and AWE enabled Thanks

Why a server would only allocate 100k to SQL Server when it's given 4gb. A client has a 2 processor / 4gb RAM server. The sqlserver.exe process is only using 100-200k and not growing. The CPU is pegged at 90-100% during peak hours. Thanks in advance

Just use method of Deattach and attaching method of database you should be fine