finding difference between two different rows of a column
Hi aLL, I have a database running oracle 10g. I want to know if there is an oracle function that takes care of difference between two values in two different rows of thesame column. Thanks Soga
Answer Question
| December 6, 2007 11:41 AM
Oracle, Oracle 10g
Hi aLL, I have a database running oracle 10g. I want to know if there is an oracle function that takes care of difference between two values in two different rows of thesame column. Thanks Soga
Answer Question
| December 6, 2007 11:41 AM
Oracle, Oracle 10g
Replication of Oracle 10g to 8i
Dear Sir, We are using Oracle 8i in our production and we have a plan to upgrade it to Oracle 10g. Lets say we have upgraded our production database to Oracle 10G and it is working fine for 1 day. After a day, lets say we found an show stopper issue which cannot be fixed [...]
Answer Question
| December 4, 2007 12:15 PM
Oracle 10g, Oracle 8i, Replication
Dear Sir, We are using Oracle 8i in our production and we have a plan to upgrade it to Oracle 10g. Lets say we have upgraded our production database to Oracle 10G and it is working fine for 1 day. After a day, lets say we found an show stopper issue which cannot be fixed [...]
Answer Question
| December 4, 2007 12:15 PM
Oracle 10g, Oracle 8i, Replication
How do you get around an ORA-06550 error?
I am making a program that will ask the user to enter a customer number. All of the customer numbers are numbers only. If the user enters in a customer number with a letter in it by mistake they will receive an ora-06550 error on that line number. How can I create an exception that [...]
Answer Question
| April 18, 2013 4:52 PM
ORA-06550, Oracle 10g, Oracle error messages
I am making a program that will ask the user to enter a customer number. All of the customer numbers are numbers only. If the user enters in a customer number with a letter in it by mistake they will receive an ora-06550 error on that line number. How can I create an exception that [...]
Answer Question
| April 18, 2013 4:52 PM
ORA-06550, Oracle 10g, Oracle error messages
Oracle Application Server
I need to install Oracle Application Server 10g on HP Proliant DL580 with dual-core 64-bit Intel Xeon processor (7140M), & with Windows 2003 64-bit. I couldn’t find any version or release for such environment, but I found for the Itanium processors. Kindly advise me about the right version & release for OAS & if I [...]
Answer Question
| February 21, 2008 8:56 AM
Oracle 10g, Oracle Application Server
I need to install Oracle Application Server 10g on HP Proliant DL580 with dual-core 64-bit Intel Xeon processor (7140M), & with Windows 2003 64-bit. I couldn’t find any version or release for such environment, but I found for the Itanium processors. Kindly advise me about the right version & release for OAS & if I [...]
Answer Question
| February 21, 2008 8:56 AM
Oracle 10g, Oracle Application Server
%rowcount in 10G
Can we use %rowcount in oracle 10G and if not what is the solution?
Answer Question
| February 5, 2008 8:57 AM
Oracle, Oracle 10g
Can we use %rowcount in oracle 10G and if not what is the solution?
Answer Question
| February 5, 2008 8:57 AM
Oracle, Oracle 10g
Oracle 10g Data Pump export through EM DB control
When I am going to use Oracle 10g data pump export, after entering of OS user name and password and do OK, it is giving me “RemoteException Error: wrong password for the user” why this error is coming pl. give me any solution thank you
Answer Question
| October 25, 2007 6:12 AM
Oracle, Oracle 10g
When I am going to use Oracle 10g data pump export, after entering of OS user name and password and do OK, it is giving me “RemoteException Error: wrong password for the user” why this error is coming pl. give me any solution thank you
Answer Question
| October 25, 2007 6:12 AM
Oracle, Oracle 10g
Connecting oracle forms 6i with oracle 10g XE
Hi everybody; my question is that i have installed oracle 10g XE after that i installed forms 6i but when i used to connect it wid oracle it gives out the error message “ORA-12203 TNS:Unable to connect to the destination”.Please help me out i am really worried what to do with this.if possible please give [...]
Answer Question
| June 23, 2010 6:37 AM
Oracle, Oracle 10g, Oracle administration
Hi everybody; my question is that i have installed oracle 10g XE after that i installed forms 6i but when i used to connect it wid oracle it gives out the error message “ORA-12203 TNS:Unable to connect to the destination”.Please help me out i am really worried what to do with this.if possible please give [...]
Answer Question
| June 23, 2010 6:37 AM
Oracle, Oracle 10g, Oracle administration
SQL behaves differently in two identical Oracle 10g db’s
I have a SQL statement that is behaving differently in two “equal” databases (equal in schema, but size differs by about 50%). Here’s the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, ’2007′, lpad(’01′,2,’0′), ’0′ from studprovider a, student b, school c where a.student_id = b.student_id and b.school_id = c.school_id and a.provider_id = 527 and [...]
Answer Question
| May 15, 2007 1:33 PM
Oracle, Oracle 10g, SQL
I have a SQL statement that is behaving differently in two “equal” databases (equal in schema, but size differs by about 50%). Here’s the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, ’2007′, lpad(’01′,2,’0′), ’0′ from studprovider a, student b, school c where a.student_id = b.student_id and b.school_id = c.school_id and a.provider_id = 527 and [...]
Answer Question
| May 15, 2007 1:33 PM
Oracle, Oracle 10g, SQL
media recovery
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Oracle 10g, Export problem through OEM
Hi, i’m trying to export my database and my user is DBA role user, and it has all the roles other than GLOBAL_AQ_USER_ROLE. After specifying all the parameters when i submit the job, it displays the following error. if i do the same steps with SYS user it works fine. “ORA-20204 usr does not exist: [...]
Answer Question
| April 23, 2008 10:48 AM
Backup & recovery, Oracle 10g
Hi, i’m trying to export my database and my user is DBA role user, and it has all the roles other than GLOBAL_AQ_USER_ROLE. After specifying all the parameters when i submit the job, it displays the following error. if i do the same steps with SYS user it works fine. “ORA-20204 usr does not exist: [...]
Answer Question
| April 23, 2008 10:48 AM
Backup & recovery, Oracle 10g
How to update a oracle table containing 4 billion records
I want to update a column on the table containing 4 billion records. The table is partitioned and all partitions are compressed except the current month. I created the following procedure to do the update (I will do the update per month): create or replace procedure update_datetime_cdrdatanew is v_charging_date cdrdata_new.charging_date%type; v_timestamp cdrdata_new.timestamp%type; v_date_time_table cdrdata_new.date_time%type; v_seq_nr [...]
Answer Question
| November 16, 2006 3:03 AM
Oracle, Oracle 10g
I want to update a column on the table containing 4 billion records. The table is partitioned and all partitions are compressed except the current month. I created the following procedure to do the update (I will do the update per month): create or replace procedure update_datetime_cdrdatanew is v_charging_date cdrdata_new.charging_date%type; v_timestamp cdrdata_new.timestamp%type; v_date_time_table cdrdata_new.date_time%type; v_seq_nr [...]
Answer Question
| November 16, 2006 3:03 AM
Oracle, Oracle 10g
How can I update a huge Oracle table containing 4 billion records
I want to update the table containing 4 billion records. The table is partitioned and all the partitions are compressed except for the current month. I added 1 column to the table and must update the column with a value. I created a procedure that must do the update. Procedure: create or replace procedure update_datetime_cdrdatanew [...]
Answer Question
| November 16, 2006 2:53 AM
Oracle, Oracle 10g
I want to update the table containing 4 billion records. The table is partitioned and all the partitions are compressed except for the current month. I added 1 column to the table and must update the column with a value. I created a procedure that must do the update. Procedure: create or replace procedure update_datetime_cdrdatanew [...]
Answer Question
| November 16, 2006 2:53 AM
Oracle, Oracle 10g
Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we’re using now for the server B the alias we’ve used for [...]
Answer Question
| November 1, 2006 11:28 AM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we’re using now for the server B the alias we’ve used for [...]
Answer Question
| November 1, 2006 11:28 AM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition
Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the form . Developer can also Click [...]
Answer Question
| October 24, 2006 9:31 AM
7 and earlier, Access, ASP.NET, Database, DataCenter, DB2, Desktops, Development, Lifecycle development, Management, Microsoft Office, Microsoft Windows, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, OS, Patch management, Programming Languages, Security, Servers, SQL, SQL Server, Visual Basic, Windows
Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the form . Developer can also Click [...]
Answer Question
| October 24, 2006 9:31 AM
7 and earlier, Access, ASP.NET, Database, DataCenter, DB2, Desktops, Development, Lifecycle development, Management, Microsoft Office, Microsoft Windows, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, OS, Patch management, Programming Languages, Security, Servers, SQL, SQL Server, Visual Basic, Windows
10G Database Restore to New Server from Backup
I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot [...]
Answer Question
| August 8, 2006 4:35 PM
Backup & recovery, Microsoft Windows, Oracle 10g
I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot [...]
Answer Question
| August 8, 2006 4:35 PM
Backup & recovery, Microsoft Windows, Oracle 10g
PL/SQL performance tuning…
I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied the tables from the [...]
Answer Question
| June 26, 2008 1:48 PM
Oracle 10g, Performance/Tuning, SQL
I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied the tables from the [...]
Answer Question
| June 26, 2008 1:48 PM
Oracle 10g, Performance/Tuning, SQL
Difference between length and vsize functions
Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik
Answer Question
| March 29, 2006 3:34 AM
7 and earlier, Database, DB2, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, SQL
Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik
Answer Question
| March 29, 2006 3:34 AM
7 and earlier, Database, DB2, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, SQL
Configuring isql *plus
Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik
Answer Question
| April 18, 2006 3:21 AM
Database, DB2, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, Oracle Manufacturing, SQL, Windows
Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik
Answer Question
| April 18, 2006 3:21 AM
Database, DB2, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, Oracle development, Oracle Manufacturing, SQL, Windows
DATABASE RECOVERY , WINDOWS 2000 , ORACLE 10G
Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed [...]
Answer Question
| May 24, 2005 4:25 PM
Database Management Systems, Microsoft Windows, Oracle, Oracle 10g
Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed [...]
Answer Question
| May 24, 2005 4:25 PM
Database Management Systems, Microsoft Windows, Oracle, Oracle 10g
what is the best STORAGE solution for ORACLE db – SAN or NAS ?
one of my project is very critical for the client . the application will run in 10 different sites . the infrastructure of each site will be : 4 linux servers (2 for ORACLE DB , 2 for websphere) + 1 linux/win server for backup software + DB oracle (~100GB) + storage. i have a [...]
Answer Question
| July 28, 2008 1:35 AM
Linux servers, NAS, Oracle 10g, Oracle 9i, SAN
one of my project is very critical for the client . the application will run in 10 different sites . the infrastructure of each site will be : 4 linux servers (2 for ORACLE DB , 2 for websphere) + 1 linux/win server for backup software + DB oracle (~100GB) + storage. i have a [...]
Answer Question
| July 28, 2008 1:35 AM
Linux servers, NAS, Oracle 10g, Oracle 9i, SAN
