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.

thanks donkeyhote, i will check it.

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.

thanks for the answer.

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.

I tried to write the following code but it fails. Create or Replace Procedure compare_tables ( v_schema_name1 IN varchar2, v_schema_name2 IN varchar2, v_dblink1_name IN varchar2, v_dblink2_name IN varchar2, v_table_name IN varchar2...

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 *...

ok,thanks.

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...

thanks LKBrwnDBA and take care!

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...