Search results for query: *

why cant you jut create a view which says create or replace view new_view as select nvl(first_column),nvl(second_column)... from <table> (or view) then use select * from in youe code or did i get ur question wrong...

hi Guys Does anybody know how to use bind variables in RDO connection to Oracle. I have a requirement of recoding a part of a module which uses oracle Database Connectivity. Can anybody help me out with this

Hi guys, Is it possible to use bind variables in VB using RDO connectivity. If so can anyone show me how to use it.

Hi guys, Could anyone help me out by giving the steps needed to configure my database to MTS . I am running the database (ver 8.1.7) in dedicated mode. How do we calculate the number of dispatchers (i.e. how do we calculate connections per dispatcher? supposing that i have around 250 users...

Hi , Has anyone used Oracle 9i Internet File system on Windows 2000. If so could you tell me how to configure E-mail . I am testing the IFS for the first time. I am using Oracle 9.0.1 version and Using Windows 2000 Server I saw in its documentation that i would need to get send mail...

hi guys, First of all i would like to say i am new to Linux (Being oracle Dba on windows) . I would like to test Oracle Database in Linux. So i want to join (? or add to the network) my linux server to the Existing Windows 2000 Domain so that users from windows can connect to the oracle...

Hi, Is it possible to shift a database from one machine to another without export and import. Here is what would like to do. I am running oracle 8.1.6.3 ON windows 2000 server (Hp machine) with datafiles,redo log files and control files on a NetApp Storage Device (Filer F720) .(log files and...

Hi, I have created around 4 listener which i dont use now how do i delete the listeners from the services I have removed them from listener.ora file. But when i go to Component services i can see that they are still there. I am using windows 2000 server with oracle 8i Thanks

hi, I was doing full import on the database when a hardware error caused the database and the server to crash. now when i am starting up the database it says media recovery required but i do not have the log files since durring import i was running the database in noarchivelog mode. Now i can...

Hi, I have just upgraded my test server to 9i from 8.1.6.0.0. Now while taking an export it is showing the following error. Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export...

Hi, could anybody tell me what 'SQL*Net message from client' waits mean and what i should do decrease 1 select SUBSTR(EVENT,1,27),TOTAL_WAITS,TOTAL_TIMEOUTS, 2 TIME_WAITED from v$system_event where time_waited<>0 3* order by time_waited desc SQL> / SUBSTR(EVENT,1,27)...

Hi, Thanks for the detailed mail .

hi, Another addition to the questions posted above. Now a days I am getting high number of log switches durring the day and at peak time upto 2-3 logswitches a min and durring the entire night only 1 or 2 for the entire night. Even with 35M redo log file why is this so? Is it because my log...

hi, yes 2 CPUs with 2 Gb Ram and Oracle files stored in a HP NetAPP Filer

hi, i am working on windows platform(2000 to be specific). how can we know the number of checkpoints happenning as i have not specified log_checkpoint_to_alert in the init file. thanks for your time

hi, i am working on windows platform(2000 to be specific). how can we know the number of checkpoints happenning as i have not specified log_checkpoint_to_alert in the init file.

hi, Thanks for your mails. spenglerr, could you explain what happens when we set log_checkpoint_timeout to 0 . if my guess is right check point should not lag behind this value and so checkpoint should happen continously ? As karluk said i am not sure whether the performance problem is...

hi, 1) The log switch happen every 10-15 min. When there is high volume of transactions then log switches happen very frequently i.e every 1 min or 1 and half min. 2)the interval of the stats were for 4 hours that is the peak of transactions.Now the log file sync wait in system event has...

hi, My problem again is with regard to redo log buffer. I just joined in a firm as a beginner and here the redo log buffer is seen to be set as 29 MB .But still the log space waits and more importantly the log file sync is seen to be increasing in an enormous rate. could anybody give me advice...

hi, My problem is as follows, 1)the redo buffer allocation retries and log space request in the V$systat increases constantly by about 2 (each of them with max of upto 12 ) durring each check point. is there any scope for tuning here and if so how. 2)I am new to this databse and it has...