Search results for query: *

hi, I am accesssing different 16 nodes(dbs) from a central database to count same tables. But sometimes networks goes down at a radomly site. In that case checking if network is down how can i continue in code to next node without drop into runtime exception? Thanks in advance. Serdar Can

hi, i write a procedure which check if the table long raw columns is same for two schemas' same tables with dmbs_lob.compare function.But at row 1771 i am getting ora-06502 :PL/SQL numeric or value error string error. i wonder why it occurs? Regards.

hi, is it true that due to 32 bit restrictions of opmn in 9.0.4,i cant use memory larger than 1596 MB. how can i make OC4J instance use more than 1 CPU. I must do OC4J clustering for this,or use more islands per OC4J? thanks in advance.

hi , i am seeking a simle reporting tool which will convert column values to simle line graphics as Excel do. what it can be? thanks in advance.

hi all, i want to learn how can i calculate jms pool,rmi connection thread pool,deamon thread pool,statement cache and connection pool sizes optimially?what are the the priorities between each one? We have an application on a OC4J and have 400 connection concurrently. is there a document...

hi all, despite i have open the monitoring and then nomonitoring of all indexes in my schema and have seen the index using from explain plan table, i can not see this info from v$object_usage. is there anything else which i must do to see this info? another question is; if i update a row in a...

hi, is there good third party tools to manage and monitor Oracle9i AS OC4J instances other than web based Oracle Enterprise Manager. Because OEM dosent give us detailed client session info in terms of cpu,memory usage we need a tool to assists us in those internals. Thanks in advance.

hi all, I am new in PL/SQL and need code assistance for the following issue. i have two same database on different locations.I want to compare the same table from these database schemas.I plan to use dblink to connect to databases and use MINUS for differences with the following format. select *...

Hi, I am using Oracle 9.2.0.1 on solaris platform. Because of my undo datafile corrupted i want to open my db without undo tablespace and then to create a new undo tablespace. (Note:Currently I have no backup.) Regards.

hi, i want to apply the DDL statements in a script file to the schemas in distributed databases. i have 16 database and each of them have 4-5 schemas ,total of 110 schema needs to be in syncronous with a master schema. how can i apply the changes(a script file which contains DML statements from...

i am using unix shell script for exporting and importing oracle table data. currently i ma using explicit username/password pair to connect oracle engine from export and import utilities. After deciding hardening to our servers i want to connect oracle engine from exp and imp with OS...

hi, i have only a tape,in it full database datafiles,archive logs,spfile and controlfile.I take this backup from NodeA,and now i want to make the same database on NodeA from this backup on NodeB.how can i do that? Note:on NodeB only Oracle Software is installed.There is no any database there...

how can i convert decimal values to its binary form in pl/sql?i used select to_bin(5) binary from dual; but it say no sucah a to_bin function. Exp: Decimal Binary -------- ------- 5 0101 Thanks in advance. Serdar Can

hi how can i backup and restore XML DB in Oracle9i? Regards. Serdar CAN.

OS:Redhat AS 2.1 Hardware: Dell Server Intel CPU at present we have one host on it there are two installations(BI and Infra Installations). our primary application runs on forms and report service(fmx and rdf files). we want to move present structure to new machines.must i do a fresh install...

At present we have one host, on it there are two installations(BI and Infra Installations). our primary application runs on forms and report service(fmx and rdf files). we want to move present structure to new machines.must i do a fresh install for it or can we clone the present machine to new...

i have tried to download postgresql-7.2.1 tar file from ftp://ftp.postgresql.org/pub/postgresql-7.2.1.tar.gz the address but i could not log into server.it asks me a login for username and password and i try anonymous/anonymous user/password but it is not accepted. is there any REAL public...

i have two string columns in my oracle db such as 12:30 and 00:10.but i want to add these two as time addition(12:15+00:40=12:55) .is there any time function in php to do this. Regards, Serdar CAN

can i create a cluster from two BI&Forms install type AS which on two different hosts on a Infra type AS Instance again on another host? how can i see the total 3 instances from oem web site?should i use the oem web site running on infra host for managing all AS instances? regards. Serdar Can

i am using connection pooling when clients get jsp files from infra db via 9iAS . but in 3-4 days these connection in pool disappear so i have to redeploy jsp scripts again .when i dont use connection pooling there is not problem but this time 9iAS has to connect infra db whenever a client...