Using Oracle 10g with our testing server what is the most efficient/easy way to backup and restore a database to a static point, assuming that you always want to go back to the given point once a backup has been created. A sample use case would be the following install and configure all software Modify data to the base testing point t...
Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle? ...
What steps do I need to take to change an IP address for Oracle 10g? I cannot connect to the database after going from a dhcp address to a static IP and a reboot. ...
I have a web application that uses JAXB 2. When deployed on an Oracle 10g app server I get errors as soon as I try to marshal an XML file. It turns out that Oracle includes JAXB 1 in a jar sneakily renamed "xml.jar". Does anyone know how I can force my webapp to use the version of the jaxb jars that I deployed in web-inf/lib over that...
We have a web application that can be deployed on many application servers, including Oracle 10g. On that platform, however, we are having classpath issues. The webapp uses JAXB 2, but Oracle 10g ships with JAXB 1, and this was causing errors. To get around those we configured Oracle to prefer classes in our webapp, but now we are get...
I have a few questions about optimizing this type of load. One builds a new table of data to be loaded into a partitioned table and then builds the indexes on this new table. Should you build the index with the COMPUTE STATISTICS option or use the Cascade option of the DBMS_Stats? Should you gather stats on the table before the swap ...
I am receiving an error from the Oracle JDBC driver (ojdbc14_g.jar) when trying to obtain a connection to a 10g database. The driver has an oracle.jdbc.driver.OracleLog class which could help but the Oracle documentation is unclear how best to use it. Has anyone had any success using this class? If so, some guidance on its use would be a...
Oracle Forms10g provides a tool to convert the Oracle Forms modules, from the binary format (.FMB) that Oracle Forms Builder works with, to text format (.FMT). For example, if you create a module called mymodule.fmb with Oracle Forms Builder, and then invoke frmcmp module=mymodule.fmb script=yes batch=yes logon=no from the command li...
I believe there is a way to do this, but I'm not familiar with ORACLE 10g as many other people are. Here's the scenario: I'm currently converting Classic ASP pages to ASP.net 2.0. I have a query that is creating a report. It's reporting Sales vs. Previous Sales. What is happening currently is one query is going out to the database and g...
I think the question title pretty much says it all, I'm preferably looking for a PL/SQL query to accomplish this, but other options might be useful too. ...
Is it possible to write a PL/SQL query to identify a complete list of a stored procedures dependencies? I'm only interested in identifying other stored procedures and I'd prefer not to limit the depth of nesting that it gets too either. For example, if A calls B, which calls C, which calls D, I'd want B, C and D reported as dependencies ...
I've been running into some problems duplicating some old ASP files into some newer .NET 2.0 code. One of the tasks is to merge the 4-5 SQL statements into one. While I have done this and had some success in performance boosts, Oracle is a new bag for me. This problem however surpasses my own SQL skills as I haven't done this before. Ba...
I use the following statement prepared and bound in ODBC: SELECT (CASE profile WHEN ? THEN 1 ELSE 2 END) AS profile_order FROM engine_properties; Executed in an ODBC 3.0 connection to an Oracle 10g database in AL32UTF8 charset, even after binding to a wchar_t string using SQLBindParameter(SQL_C_WCHAR), it still gives the error ORA-12...
I've got an insert into a table using ODBC 3.0 on Oracle 10g that is failing and I have no idea why. The database is on Windows Server 2003. The client is on Windows XP. The table: CREATE TABLE test ( testcol NUMBER(20,0) NULL ); The ODBC calls: SQLAllocHandle(SQL_HANDLE_STMT) = SQL_SUCCESS SQLPrepare(INSERT INTO test (testcol) VALU...
We are trying to populate a domain object from an oracle 10g database. The field in question is defined as a string in the domain object with the following constraints. zdata(blank:false,maxSize:3000000) The size of the data is approximately 70K of XML. The table definition looks like this: ZDATA NOT NULL ...
How can I get a PL/SQL block to output the results of a SELECT statement the same way as if I had done a plain SELECT? For example how do a SELECT like: SELECT foo, bar FROM foobar; Hint : BEGIN SELECT foo, bar FROM foobar; END; doesn't work. ...
I'll try and make it a fair reflection of my actual query. It's more to settle my confusion. Let's start at the beginning. A web front end hosted somewhere and numerous clients inserting data into web forms which is sent to and Oracle 10G database via stored procs. I have no idea of client settings nor the web server settings. So I h...
I am currently running into a problem when trying to import an Oracle 9i SQL script into my local Oracle 10g Express database. I am trying to import the DDL from the 9i database to the 10g express database. I keep getting "Not compatible - Your export file is not supported". Has someone been able to get this working? Please let me know w...
We have a table, name 'employeeReg' with fields employeeNo | employeeName | Registered_on Here *Registered_on* is a timestamp. We require an hourly pattern of registrations, over a period of days. eg. 01 Jan 08 : 12 - 01 PM : 1592 registrations 01 Jan 08 : 01 - 02 PM : 1020 registrations Can someone please suggest a query ...
The server I am running oracle on is suffering from out of memory errors. Anyone know if/how I can limit the global memory resources that oracle will use? I have SGA_TARGET_MAX = 500M and a session/process limit of 150, but our max concurrent sessions have not reached above 50. ...