Build relationship between two tables from different Oracle databases

Can I build a relationship between two tables from different Oracle databases?

hahamama5 pointsBadges:

ORA-01000: maximum open cursors exceeded

I'm getting the ORA-01000: maximum open cursors exceeded in one XML. How do I resolve this? All result set and statements are closed in finally block.

Nikhitasuresh5 pointsBadges:

Oracle opportunities

I completed my B.E in 2009, so I want interested to go to Oracle side, so I know the concept of SQL and PL/SQL. Relating to this I dont have a project of this. So please give me some titles of project at least I can go through this. Regards.

Ingalagi5 pointsBadges:

I would like to install Oracle database on OS X MacBook

I have looked in the Oracle Technet site for a version of Oracle suitable for OS X.  I downloaded Oracle 10.2.0.4.0 because it said that it was compatible with Mac OS X. However, when I attempted to install the application, nothing happened. Upon closer look, the documentation seem to point to Max...

JavierS45 pointsBadges:

Integration of Oracle Reports with Oracle Forms

How do I integrate Oracle Reports in Developer Suite 10g with Oracle Forms?

AMJAD5 pointsBadges:

View .pdf file from Oracle Forms 10g

Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files...

NasoTang5 pointsBadges:

Create an Oracle database

How do I create an Oracle database?

PSS10 pointsBadges:

Is it possible to run a query on two tables in two physical databases using MySQL?

I understand that an Oracle database allows users to query on several physical databases. Does anyone know if there's a MySQL equivalent? I'm trying to run a query on two tables (which are in two different physical databases). Would it be possible to do this in MySQL?

ITKE1,068,015 pointsBadges:

Export data from Forms to Excel

How to export the selected data from Forms to Excel?

Brithivi5 pointsBadges:

Connecting D2K 6i with Oracle database 11g

I'm having a problem connecting D2K 6i with Oracle database 11g. What should I do?

manishbarbate10 pointsBadges:

Importing dmp file

What is the procedure for importing a dmp file?

PSS10 pointsBadges:

64-bit client to 32-bit database

I have a 64-bit client that is trying to connect to my oracle database which is a 32 bit machine. Is this possible? They have tried to use the 32-bit client software on the 64-bit machine. Is this the problem? Is there 62client software for Oracle 9i? Really need your help on this one. Thanks!

Rwbaker15 pointsBadges:

Oracle: Can a character set be changed after a schema has been created?

My boss was so pleased with the response from this site that he asked me to ask another question! He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!). In any case, we build a new db (schema) prior to...

DeloeranGuy55 pointsBadges:

Develop import process in PeopleSoft

Hi, I want the steps to develop import process in PeopleSoft?

samsforever5 pointsBadges:

Adding a node in Oracle 10g

How can a third node be added in Oracle 10g standard edition? Server being used is DELL 2850.

Akansha150 pointsBadges:

External Table / SQL Loader

Hi, We are using this new SQL loader for a month now and it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge...

External10 pointsBadges:

Following Oracle WebLogic Server as a career

Would following Oracle WebLogic Server turn into a good career?

rajeshpvg265 pointsBadges:

How to install Oracle 7 in Windows XP

There is an application which runs using oracle 7 and it is running in system which is win NT but now need to run that application in XP which does not have Oracle 7 it has higher version 8.1.7 and 9. Can anybody help me in finding the solution here? How can I install Oracle 7 in there. Thanks

Pag285 pointsBadges:

Oracle Application Freezing up

Oracle alert log has below error occurring frequently. How to troubleshoot message? Fatal NI connect error 12170. VERSION INFORMATION: TNS for 32-bit Windows: Version 11.1.0.6.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production Windows NT TCP/IP NT...

Cathyhaskins384115 pointsBadges:

Discuss the impact of Oracle-Sun with your peers and SearchOracle.com Editors

Oracle has announced that it has reached an agreement to acquire Sun Microsystems for $7.4 billion. Please use the discussion comments below to discuss the Oracle/Sun deal with fellow members and the SearchOracle.com editors. Please use the Add to Discussion button (not the answer section) to...

OracleATE190 pointsBadges: