Accessing Oracle database on Linux from Mainframe
I want to read some data from Oracle 9i tables running on Linux machine. Can some ne help me as I am not very expert on mainframe systems Thanks.

Answer Question   |  November 19, 2005  3:23 AM
AS/400, DB2 Universal Database, Linux, Oracle

Is java better thab vb ?
what do you think about this ? is that worth to learn java or you think the future is for vb?

Answer Question   |  November 3, 2005  12:04 AM
Database, DB2, Oracle

Question about a frequently changing column as primary key
Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance issues, [...]

Answer Question   |  December 12, 2005  9:27 AM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows

VB app connecting to Oracle database
I have a custom VB application that connects to an Oracle database (9.2.0.5). It inserts records into an interface table then disconnects from Oracle. The VB app is on about 400 PCs with about 5000 inserts into the interface table daily. My question is having this app connect and disconnect so many times all day [...]

Answer Question   |  November 22, 2005  8:49 AM
Oracle

Dbms_repair
Hello, i have a corrupted data block one one of my datafiles. I want to use dbms_repair to repair it or mark it. What’s the command ? Thanks

Answer Question   |  November 10, 2010  3:17 AM
Oracle

Performance degraded after changing optimizer mode
Hi all, I facing a strange problem. Please help me. Server = Windows 2003 Oracle version – oracle 9.2.0.1.0 (standard edition) I have done the some changes at my client side. I done changes as follows.. 1) Tunning has done on dated 22/10/05 i) The database archive log mode has changed to Archive log mode. [...]

Answer Question   |  November 3, 2005  2:49 AM
Oracle, Windows

Synchronizing expired merge subscription database with publication database
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.

Answer Question   |  October 28, 2005  11:08 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff

ORACLE Question – Split data in 90 days chunk
I need to aggregate data in 90 days chunk. For example, I have following data. Date Custorm Qty 1/5/05 1 7 3/31/05 1 9 5/10/05 1 10 I need to sum(qty) for chunk of 90 days. The chunks should be such that the first chunk starts on 1/5/05, and goes to 4/5/05 (1/5/05 + 90 [...]

Answer Question   |  October 28, 2005  12:34 PM
Oracle

Oracle Import
I am trying to do export from vax alpha oracle 8.1 to Linux Oracle 9i I am getting following error in Import on Linux Oracle 9i machine IMP-00010 : not a valid export file , header failed verification. Can you suggest something? I thought earlier may be file not in binary or got corrupted in [...]

Answer Question   |  October 31, 2005  3:28 PM
Database, DB2, Oracle

Oracle Import to Linux
I have full export dump from Oracle database version 8i from Vax/alpha machine. I want to impoet to Linux system which has Oracle 9i installed What steps should I do?

Answer Question   |  October 26, 2005  5:04 AM
Database, DB2, Oracle

Knowing the number of rows in a cursor
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]

Answer Question   |  October 27, 2005  5:19 PM
Database, DB2, Oracle, SQL, Windows

oracle error
Hi, pl respond urgently The following error has occured while executing a package. The following error has occurred: ORA-21000: error number argument to raise_application_error of -6508 is out of range ORA-06512: at “ECW_LOADER.CREATE_CTL_RANGES”, line 154 ORA-06512: at line 19

Answer Question   |  October 25, 2005  2:58 AM
Oracle, Windows

Deleting duplicate rows based on timestamps
Hello.. I’m quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I’d like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp [...]

Answer Question   |  October 22, 2005  1:11 PM
Database, DB2, Oracle, SQL

Database cleanup
Background: Oracle 9.2.0 running on win2k q1: I need to find out which objects have not been in used for > 6 mths. How do i do this? q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know [...]

Answer Question   |  November 4, 2005  10:42 PM
Database, DB2, Oracle

Database Upgrade
1) I am migrating a database to 10G (from 9i) to a new server. The database is the backend for Forms and Reports (currently running 9iAS). How will moving the database to a new server, and upgrading, affect the current application server environment? Other than changing the TNS entry on the web server to point [...]

Answer Question   |  October 21, 2005  7:15 PM
Oracle, Windows

execute dbms_utility.analyze_schema
I tried to run the floowing command : execute dbms_utility.analyze_schema(‘CALLSINFO’,'ESTIMATE’,500,0,’for table for all indexes for all indexed columns’); and i am having this error: ERROR at line 1: ORA-00376: file 1629 cannot be read at this time ORA-01110: data file 1629: ‘G:ORADATACDRSTS_SMS_MT_NOV2006_FILE#02.DF’ ORA-06512: at “SYS.DBMS_DDL”, line 179 ORA-06512: at “SYS.DBMS_UTILITY”, line 472 ORA-06512: at line [...]

Answer Question   |  June 4, 2012  3:12 PM
Database, DB2, Oracle

accessing oracle application thru internet
currently we are using this address to login to the application within LAN http://oracle-svr.gsmsc.com:8000/dev60cgi/f60cgi what is the next step in order to let external user to log in? is it there any port i need to open on the firewall?and where should those ports pointing to? currently my oracle application 11.5.9 is install on a [...]

Answer Question   |  November 3, 2005  12:26 AM
E-business, Oracle

Need help with max function within a left outer join
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.

Answer Question   |  October 19, 2005  8:57 AM
Database, DB2, Oracle, SQL

What is wrong with my code?
Posed on behalf of SearchOracle member Deepa: Question: How can I get a oracle database connection? Here is a code to which accepts username and password and checks for validation. is it correct? Pls tel me import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.lang.String; public class Form extends HttpServlet{ private ServletConfig config; private [...]

Answer Question   |  October 19, 2005  6:43 AM
Oracle

Help using oracle Analytical function.
I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from [...]

Answer Question   |  October 28, 2005  7:16 PM
Oracle, SQL, Windows