I am not getting source of oracle.I searched a lot but was not able to get it from anywhere.Plz help me.
And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only
And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only
20 pts.
Errors Registering Recovery Catalog in 10g Grid
I have a 2 node RAC environment that I am trying to catalog in a database that is not part of the RAC instances, but is a tablespace in the Oracle Grid control database. This is a testing environment so my configuration may not be the most secure, but the production environment will have a...
I have a 2 node RAC environment that I am trying to catalog in a database that is not part of the RAC instances, but is a tablespace in the Oracle Grid control database. This is a testing environment so my configuration may not be the most secure, but the production environment will have a...
Windows performance setting for Oracle
We are looking at our db performance (10gR2 on Win 2003 SP2) and am wondering what setting would give the better performance for the db. The server is only hosting the oracle backend for BMC Remedy 7.1p6. Its a DL580 with 8GB ram. The factors I'm looking at at the OS level is: - Paging: system...
We are looking at our db performance (10gR2 on Win 2003 SP2) and am wondering what setting would give the better performance for the db. The server is only hosting the oracle backend for BMC Remedy 7.1p6. Its a DL580 with 8GB ram. The factors I'm looking at at the OS level is: - Paging: system...
Would like to upgrade to 10.2.0.4 from 9.2.0.7
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
HOW TO SAVE DATA FAST
I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad's save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, ...
I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad's save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, ...
Online Question and answers on Oracle or any other language
Is there any site which provide the facility in which we can ask questions about the oracle and at a time we get the answer. If we have dabase related question then also we get the answer is there site and if yes then reply....
Is there any site which provide the facility in which we can ask questions about the oracle and at a time we get the answer. If we have dabase related question then also we get the answer is there site and if yes then reply....
Web based forms and Oracle databases
I am researching software that designs/builds web based forms for data input and output that will work with Oracle. I am looking for suggestions on the newest most efficient software available for designing, creating and managing webforms that comunicate to an Oracle database
I am researching software that designs/builds web based forms for data input and output that will work with Oracle. I am looking for suggestions on the newest most efficient software available for designing, creating and managing webforms that comunicate to an Oracle database
I want to conect oracle form 6i to oracle 10g data base
I want to connect Oracle form6i fmx to oracle 10g data base presently i am connecting at client side making shortcut in path i use to write :C:\orant\BIN\ifrun60.EXE c:\MS\FORMS\ERP_LOGIN erp_ss/ss@sdcl in this method End user is knowing User name and password and connecting string. Is there any...
I want to connect Oracle form6i fmx to oracle 10g data base presently i am connecting at client side making shortcut in path i use to write :C:\orant\BIN\ifrun60.EXE c:\MS\FORMS\ERP_LOGIN erp_ss/ss@sdcl in this method End user is knowing User name and password and connecting string. Is there any...
What am I doing wrong. Please Help
An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As...
An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As...
Oracle database and Crystal
How can I connect oracle database to Crystal XI?
View Answer
| Feb 26 2009 2:31 PM GMT
Oracle Database, Crystal Reports XI, Connecting Oracle Database to Crystal XI
How can I connect oracle database to Crystal XI?
View Answer
| Feb 26 2009 2:31 PM GMTOracle Database, Crystal Reports XI, Connecting Oracle Database to Crystal XI
ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property 'SERVER' returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property 'SERVER' returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?
oracle sync index job log file
Hi, I am using windows 2003 server with oracle database 10g enterprise edition. I created a procedure and scheduled job to do sync text indexes. I am using parallel 2 for my sync index job. the proble is: After i enable the log file option, ctx_output.start_log('SYNC_INDEXES_JOB.TXT');...
Hi, I am using windows 2003 server with oracle database 10g enterprise edition. I created a procedure and scheduled job to do sync text indexes. I am using parallel 2 for my sync index job. the proble is: After i enable the log file option, ctx_output.start_log('SYNC_INDEXES_JOB.TXT');...
Finding which columns contain data in a table
I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 ...
I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 ...
How does one COMMENT a table ONLY if it has NO comment?
I am importing comments on 1500 tables from a separate source. I would like to put a comment on each table ONLY if one does not currently exist (COMMENTS field is NULL). A command like: COMMENT ON TABLE owner1.table1 IS 'Test 4 adding comment' WHERE owner = 'OWNER1' AND...
I am importing comments on 1500 tables from a separate source. I would like to put a comment on each table ONLY if one does not currently exist (COMMENTS field is NULL). A command like: COMMENT ON TABLE owner1.table1 IS 'Test 4 adding comment' WHERE owner = 'OWNER1' AND...
Oracle Statspack
I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off...
I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off...
SQL Query
Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ---------- ---------- -------- 1 3 01-12-08 1 ...
Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ---------- ---------- -------- 1 3 01-12-08 1 ...
How to synch Lotus notes grop/contacts to my java application group/contacts ?
Hi, I am new to lotus notes and wanted to synch lotus notes group/contacts to our application which is java. The requirement is we need a facility to copy/synch the lotus notes group details (including the group member contacts to the application ), that is a one way (from lotus notes to...
Hi, I am new to lotus notes and wanted to synch lotus notes group/contacts to our application which is java. The requirement is we need a facility to copy/synch the lotus notes group details (including the group member contacts to the application ), that is a one way (from lotus notes to...
