ORA-03127: no new operations allowed until the active operation ends
Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can anyone tell me why this error [...]

Answer Question   |  March 22, 2012  12:13 PM
ORA-03127, Oracle 11g, Oracle Reports 10g

select command
i would like to collect informations from oracle date table through select query financial year wise my financial year starts from01 jul and ends on 30 jun. my task is to collect total number of entries from last ten financial years wise.

Answer Question   |  March 22, 2012  7:49 AM
Oracle, Oracle commands, Oracle Table

migrate from oracle 9 to oracle 11
Can one migrate from oracle9 to oracle11 without migrating to oracle 10? If yes, what premigration settings are required?

Answer Question   |  March 20, 2012  4:18 AM
Oracle 11, Oracle 9, Oracle migration

How to Insert Picture in Excel Report through Oracle
I have a table Name Emp_master. In this table having a column Pic_path varchar2(100). In this column employee picture path capture like ‘d:emp_pictureJohn.jpg’. I want to generate a report in Excel through Oracle having column like Emp_Code, Emp_Name & Emp_Picture. Please help

Answer Question   |  March 27, 2012  10:34 AM
Oracle 6, Oracle Reports

how to transfer oracle table data to .csv file by using pl/sql coding
how to transfer oracle table data to .csv file by using pl/sql coding

Answer Question   |  March 14, 2012  7:14 AM
.CSV files, Oracle, Oracle Table

oracle 11g – Linux – error – ORA-03114
Hi, i´m having a major instability problem with application servers, since the migration from oracle 10g windows db server to oracle 11g linux cluster. The oracle db sessions keep dying. which causes major instability to the application services , and to application users and i get tons of oracle errors: ORA-03114:  not connected to ORACLE help.thanks.

Answer Question   |  March 13, 2012  9:45 AM
Linux, Oracle 11g, Oracle 11g error messages

Compressing/Compacting Tablespace and Data Files
Can some one give me some advice on how to best compress or compact a Tablesapce so that I can recover disk space? Many thanks, Sam

Answer Question   |  March 5, 2012  10:06 PM
Oracle, Oracle 10g

Oracle SaaS license
We have build an application for the Dutch soccer association running in a private cloud. We want to extend this to other sports and countries using a SaaS model. Oracle has launched a SaaS license for ISV’s. We are currently use Oracle SE. Which Oracle license do we need for the (external users) SaaS environment. [...]

Answer Question   |  February 27, 2012  10:17 PM
Oracle Database Versions, Oracle SaaS license

login form for Oracle
hi,  i want to create a login form that validates the username and password from the database.  the username and passwors are stoed in the database. table:login column: empid, password

Answer Question   |  February 27, 2012  3:46 PM
Oracle, Oracle Database, Oracle Forms

Populate List Item in Oracle
I would like to populate list item, plz help me.

Answer Question   |  February 28, 2012  4:44 PM
Oracle 6i, Oracle 6i import/export

Oracle Multi-Master Replication
Hi.  I have set up Oracle Multi-Master Replication between two 11g’s, and it works OK. (Each database updating the other with the latest updates).  But I have not been able to get one database to automatically update the other when one has been taken off-line then reconnected after changes had been made to one of them.  Will you [...]

Answer Question   |  February 27, 2012  9:40 PM
Oracle 11g, Oracle replication, Windows XP Pro

cubes and databases
What exactly is a cube and how does it work

Answer Question   |  February 28, 2012  5:14 AM
Oracle 6, Oracle Database

commit and rollback on triggers
Can we use commit and rollback statements in procedures that will be invoke by triggers?

Answer Question   |  February 28, 2012  11:43 AM
Oracle, Oracle 10g, Oracle 10g triggers

Oracle report 10
hi Friends, I had created drill down reports using hyperlink. rep_1 dispalying various Location_cd. by clicking location_cd The parameter form of rep_2 is displayed in which location_cd is displayed which is already selected and accept dept_cd from user. While running the rep_2 the parameter location_cd is passing null value for testing i m dispaying it [...]

Answer Question   |  April 28, 2012  7:56 AM
Oracle Reports 10g

commit and rollback on triggers
why we cannote use commit and rollback in triggers?

Answer Question   |  February 28, 2012  7:53 AM
Oracle 10g, Oracle 10g triggers

Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8
I have Oracle 10g running on Solaris 8. I would like to do direct queries from this server to a table on a MySql 5.0 database residing on a Microsoft Server 2003. Are there step-by-step instructions around? ie. Drivers for both ends; admin/config on both ends, etc. Thanks.

Answer Question   |  February 28, 2012  9:02 PM
MySQL 5.0, Oracle 10g, Solaris 8, Windows Server 2003

about oracle installation
how to install oracle in windows 7 home basic

Answer Question   |  April 19, 2012  7:54 AM
Oracle, Oracle installation, Windows 7

How can I Send report output to 3 different printer programatically
Dear Friends How can I Send report output to a printer, I have three different printers in three location so how can I Send the report output to those three printer automatically when the user press the print button . please give an example if it is possible Waiting for your valuable answer. Best regards [...]

Answer Question   |  February 28, 2012  6:38 AM
Oracle 6, Oracle Reports, Oracle Reports 6i

Oracle
Dear sir I am in problem , please help me How to change the direction of the report automatically by the code and not through the design phase in oracle 6i

Answer Question   |  February 28, 2012  7:17 PM
Oracle 6i, Oracle 6i Reports Builder

Using the java import utility to add word document in a 10g report
- i want to add a word document in my oracle 10 g report , please send me how to activate the java import utility and how to modify the configuration files if needed in details.

Answer Question   |  January 25, 2012  8:59 AM
java import utility, Oracle 10g, Oracle 10g reports