Search results for query: *

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

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

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

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

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

We have 78 gb of database. what is the best practice and how ofen to run reindexing on the database. Thanks in advance

Anyone enlighten me steps for settings for check point when doing transaction logs. Thanks

Our database is roughtly 75 gb which to take backups in 1 hr 20 m but now it taking roughtly 3 hrs to complete it . Any thoughts how to check bottoleneck what is going wrong? Thanks in advance

I'm in dilemma how to run different schema users using single login. I'm not favourable of running by system, sys users. I have customer,audit,users schemas how to run these schema using single login instead of schema user itself. Just for though by giving dba permission to that user will I...

Anyone walk through to apply multiple transaction logs in sequence. Thanks in advance

Can anyone help me with steps into to create new instance in aix environment.

I have an aspx page which is giving me HttpException (0x80004005): Request timed out.] only on the production server. In the development and Test servers it works fine. Even if I point to the production database from my development box it doesn’t throw me the error. We have tried indexing on the...

I have to call different javascript functions in the btnSubmit_click event in code behind based on txtbalancedue value. If txtbalancedue = 0 then I have to call a js function and capture value. If the value is true then I have to call a update method in code behind. If txtbalancedue == 1 then I...

Anyone give me steps to load data from excel sheet to oracle table. Thanks in advance

I have a file upgrade.tar. Any one tell me step to untar this file after ftp to aix box. Thanks in advance

I need to call different javascript functions based on the conditions in submit button click. if(balancedue == 0) //call javascript function to confirm else //call another javacript function to confirm. How can I call based on the conditions. In page_load event btnsubm.Attribute.Add can only...