COMMUNITY ANNOUNCEMENT: Tell us your Data Center Tales and you could win a Nintendo Wii
Tell us you Data Center stories today.! First post is a good one: <a href=”http://itknowledgeexchange.techtarget.com/tales-from-the-data-center/tag/data-center-contest-entries/”>Tales from the Data Center</a> Some tales posted today. Enjoy.
View Answer
| October 16, 2008 9:20 PM
AS/400, CIO, Database, DataCenter, Development, Exchange, Linux, Microsoft Windows, Networking, Oracle, Security, Storage, Virtualization
Tell us you Data Center stories today.! First post is a good one: <a href=”http://itknowledgeexchange.techtarget.com/tales-from-the-data-center/tag/data-center-contest-entries/”>Tales from the Data Center</a> Some tales posted today. Enjoy.
View Answer
| October 16, 2008 9:20 PM
AS/400, CIO, Database, DataCenter, Development, Exchange, Linux, Microsoft Windows, Networking, Oracle, Security, Storage, Virtualization
SQL Connectivity with Developer 2000
You will need to use the Oracle Open Client Adapter for ODBC (OCA) to achieve this. A file called “oca_info.pdf” should be included in your Developer installation, which is usually at “ORACLE_HOMETOOLSDOCXXUS”. In this file you will find all the information you need to connect Developer to other databases (including SQL Server). If you don’t [...]
View Answer
| October 16, 2008 4:19 PM
Database connectivity, Developer 2000, SQL Server 2000
You will need to use the Oracle Open Client Adapter for ODBC (OCA) to achieve this. A file called “oca_info.pdf” should be included in your Developer installation, which is usually at “ORACLE_HOMETOOLSDOCXXUS”. In this file you will find all the information you need to connect Developer to other databases (including SQL Server). If you don’t [...]
View Answer
| October 16, 2008 4:19 PM
Database connectivity, Developer 2000, SQL Server 2000
Transfer Oracle database
Have a look at these links: <a href=”http://www.orafaq.com/wiki/Import_Export_FAQ”>Import Export FAQ</a> <a href=”http://www.psoug.org/reference/export.html”>Oracle Export Utility</a> <a href=”http://www.psoug.org/reference/import.html”>Oracle Import Utility</a> You should also take a look at your Oracle Documentation, which contains a complete description and examples of import and export utilities. If you have any specific questions, feel free to post them here.
View Answer
| October 15, 2008 4:14 PM
Oracle import/export, Oracle migration
Have a look at these links: <a href=”http://www.orafaq.com/wiki/Import_Export_FAQ”>Import Export FAQ</a> <a href=”http://www.psoug.org/reference/export.html”>Oracle Export Utility</a> <a href=”http://www.psoug.org/reference/import.html”>Oracle Import Utility</a> You should also take a look at your Oracle Documentation, which contains a complete description and examples of import and export utilities. If you have any specific questions, feel free to post them here.
View Answer
| October 15, 2008 4:14 PM
Oracle import/export, Oracle migration
NUMBER IN A LIST
ORA-01722 is raised when you are trying to convert a character string to a number, but the string is not really a number. It is not clear enough to me what are you trying to do. Could you please paste your update statement here, and explain what are the data types of the involved table [...]
View Answer
| October 15, 2008 3:53 PM
ORA-01722, Oracle error messages
ORA-01722 is raised when you are trying to convert a character string to a number, but the string is not really a number. It is not clear enough to me what are you trying to do. Could you please paste your update statement here, and explain what are the data types of the involved table [...]
View Answer
| October 15, 2008 3:53 PM
ORA-01722, Oracle error messages
Monitoring Object changes in Oracle
use the LAST_DDL_TIME find changes select * from dba_objects where LAST_DDL_TIME > SYSDATE – 7 but this will not tell you who altered it
View Answer
| October 14, 2008 3:08 PM
dba_objects, Oracle 10g, Oracle 11i, Oracle 9i, Oracle administration, Sarbanes-Oxley Act, SOX
use the LAST_DDL_TIME find changes select * from dba_objects where LAST_DDL_TIME > SYSDATE – 7 but this will not tell you who altered it
View Answer
| October 14, 2008 3:08 PM
dba_objects, Oracle 10g, Oracle 11i, Oracle 9i, Oracle administration, Sarbanes-Oxley Act, SOX
Oracle initialization error while running Java files
This error usually means that you are trying to establish a connection to an Oracle database that is currently being started up or shut down. Try connecting to the database from sql*Plus or any other tool and see what happens. You might also want to review the database process status (process name: OracleService<your_database_name>).
View Answer
| October 13, 2008 4:26 PM
Java, java.sql.SQLException, ORA-01033, Oracle error messages
This error usually means that you are trying to establish a connection to an Oracle database that is currently being started up or shut down. Try connecting to the database from sql*Plus or any other tool and see what happens. You might also want to review the database process status (process name: OracleService<your_database_name>).
View Answer
| October 13, 2008 4:26 PM
Java, java.sql.SQLException, ORA-01033, Oracle error messages
Send email via Oracle Forms
Use the oracle built in package UTL_SMTP to generate mail
View Answer
| October 13, 2008 3:37 PM
Oracle 10g, Oracle Forms
Use the oracle built in package UTL_SMTP to generate mail
View Answer
| October 13, 2008 3:37 PM
Oracle 10g, Oracle Forms
ORA-12560: TNS:protocol adapter error
Things to check: - Have you created the Designer repository ? - ORA-12560 usually has something to do with your tnsnames.ora file. Check that you have the correct configuration to connect to the database in which the repository resides.
View Answer
| October 8, 2008 4:38 PM
ORA-12560, Oracle Designer, Oracle error messages, RME-00220
Things to check: - Have you created the Designer repository ? - ORA-12560 usually has something to do with your tnsnames.ora file. Check that you have the correct configuration to connect to the database in which the repository resides.
View Answer
| October 8, 2008 4:38 PM
ORA-12560, Oracle Designer, Oracle error messages, RME-00220
Oracle forms app run on Client
What error messages are you getting ? Note JINI does not work on IE7 on VISTA you have to load the latest JAVA runtime from sun and run it directly see <a href=”http://onlineappsdba.com/index.php/2008/10/03/deploying-sun-jre-native-plug-in-for-windows-clients-in-oracle-e-business-suite-11i/”>Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i</a>
View Answer
| October 8, 2008 4:03 PM
DS10g, DS6i, Oracle 10g, Oracle Application Server
What error messages are you getting ? Note JINI does not work on IE7 on VISTA you have to load the latest JAVA runtime from sun and run it directly see <a href=”http://onlineappsdba.com/index.php/2008/10/03/deploying-sun-jre-native-plug-in-for-windows-clients-in-oracle-e-business-suite-11i/”>Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i</a>
View Answer
| October 8, 2008 4:03 PM
DS10g, DS6i, Oracle 10g, Oracle Application Server
connection of oracle8i i vb6.0
There are many ways to connect to Oracle from a VB application. You can use an ODBC connection and/or use ADO (ActiveX Data Objects). You can also use RDO. If you want to connect via ADO you will need to create an ODBC data source or install the Oracle client software in the client machines. [...]
View Answer
| October 7, 2008 2:22 PM
Oracle 8i, VB 6
There are many ways to connect to Oracle from a VB application. You can use an ODBC connection and/or use ADO (ActiveX Data Objects). You can also use RDO. If you want to connect via ADO you will need to create an ODBC data source or install the Oracle client software in the client machines. [...]
View Answer
| October 7, 2008 2:22 PM
Oracle 8i, VB 6
form10g error
Make sure to start OC4J before running the form, and be sure the port number (8224) is correct, since I think that is not the default port number. If you have the port number incorrect, in forms builder go to Edit->Preferences->Runtime, and set the appropriate ip address and port number. Hope this helps.
View Answer
| October 6, 2008 4:29 PM
FRM-10142, FRM-10142 HTTP Listener, Oracle 10g, Oracle Forms
Make sure to start OC4J before running the form, and be sure the port number (8224) is correct, since I think that is not the default port number. If you have the port number incorrect, in forms builder go to Edit->Preferences->Runtime, and set the appropriate ip address and port number. Hope this helps.
View Answer
| October 6, 2008 4:29 PM
FRM-10142, FRM-10142 HTTP Listener, Oracle 10g, Oracle Forms
do_while how can i use do while statement to delete certain rows based on the rowcount?
“rowcount” does not really exist as part of the data. It is something generated at the moment of retrieving the data from the database, so you cannot use it to delete or update rows. One option could be the rowid, but depending on what you want to accomplish, I think a better option is to [...]
View Answer
| October 3, 2008 11:52 PM
PL/SQL
“rowcount” does not really exist as part of the data. It is something generated at the moment of retrieving the data from the database, so you cannot use it to delete or update rows. One option could be the rowid, but depending on what you want to accomplish, I think a better option is to [...]
View Answer
| October 3, 2008 11:52 PM
PL/SQL
How can I get my Oracle load script to recognize decimal data with a trailing minus sign?
Format mask for trailing minus sign (negative values) or trailing space (positive numbers) is, for example, 9999.99MI (the number of nines should match your data). So in your control file you would do something like LOAD DATA … ,yournumberfield “to_date(:yournumberfield,’9999.99MI)” ,…
View Answer
| October 3, 2008 2:53 PM
Oracle, Oracle control file, Oracle load script
Format mask for trailing minus sign (negative values) or trailing space (positive numbers) is, for example, 9999.99MI (the number of nines should match your data). So in your control file you would do something like LOAD DATA … ,yournumberfield “to_date(:yournumberfield,’9999.99MI)” ,…
View Answer
| October 3, 2008 2:53 PM
Oracle, Oracle control file, Oracle load script
oracle forms 6i, export, import
is it possible for you to use the COMMIT option, at least for testing ? Specifying COMMIT=Y prevents rollback segments from growing inordinately large and improves the performance of large imports, but it is only advisable if the table has uniqueness constraints, so if the import fails and it is restarted, any rows that have [...]
View Answer
| October 1, 2008 9:52 PM
Export, Import, Oracle Forms 6i
is it possible for you to use the COMMIT option, at least for testing ? Specifying COMMIT=Y prevents rollback segments from growing inordinately large and improves the performance of large imports, but it is only advisable if the table has uniqueness constraints, so if the import fails and it is restarted, any rows that have [...]
View Answer
| October 1, 2008 9:52 PM
Export, Import, Oracle Forms 6i
oracle 9i instalation
I think Oracle could be a good option for learning, and you will be able to practice SQL and much more, and the express edition can be downloaded and used free of charge. In the Oracle Technology Network (OTN) site you can find very helpful documents and tutorials . I would recommend to download the [...]
View Answer
| October 1, 2008 9:14 PM
Oracle 9i, Oracle installation, SQL, SQL queries
I think Oracle could be a good option for learning, and you will be able to practice SQL and much more, and the express edition can be downloaded and used free of charge. In the Oracle Technology Network (OTN) site you can find very helpful documents and tutorials . I would recommend to download the [...]
View Answer
| October 1, 2008 9:14 PM
Oracle 9i, Oracle installation, SQL, SQL queries
Resetting the database
Have you used a rescued disk for the database, or restored using your most recent snapshot? Hope this helps! -Schmidtw
View Answer
| October 1, 2008 2:48 AM
Catalog management, Oracle error messages, Oracle Recovery Manager, Restore Database, RMAN, RMAN-03008, RMAN-20042
Have you used a rescued disk for the database, or restored using your most recent snapshot? Hope this helps! -Schmidtw
View Answer
| October 1, 2008 2:48 AM
Catalog management, Oracle error messages, Oracle Recovery Manager, Restore Database, RMAN, RMAN-03008, RMAN-20042
update date value in oracle 9i
Have a look at <a href=”http://www.oracle.com/technology/pub/articles/price_dbtrans_dotnet.html”>this Oracle Document</a> which explain the basics about coding transactions. There is good example of an insert statement, explained step by step. If what you need to do is an update, just replace the sql command int the example, with the desired update statement. Summarizing : -Importing the Namespaces <pre>Imports [...]
View Answer
| September 30, 2008 11:26 PM
Oracle, Oracle 9i, VB.NET, VB.NET 2005, Visual Basic .NET
Have a look at <a href=”http://www.oracle.com/technology/pub/articles/price_dbtrans_dotnet.html”>this Oracle Document</a> which explain the basics about coding transactions. There is good example of an insert statement, explained step by step. If what you need to do is an update, just replace the sql command int the example, with the desired update statement. Summarizing : -Importing the Namespaces <pre>Imports [...]
View Answer
| September 30, 2008 11:26 PM
Oracle, Oracle 9i, VB.NET, VB.NET 2005, Visual Basic .NET
Why do IT projects fail?-3
First of all, I absolutely agree with Bob’s points. I had a few additional thoughts: + A very basic reason for project failure is that it does not follow any formal project methodology, which, sadly, is true in too many organizations. Not folling project metholdogies will allow just about anyting to derail any project. It [...]
View Answer
| September 30, 2008 8:11 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
First of all, I absolutely agree with Bob’s points. I had a few additional thoughts: + A very basic reason for project failure is that it does not follow any formal project methodology, which, sadly, is true in too many organizations. Not folling project metholdogies will allow just about anyting to derail any project. It [...]
View Answer
| September 30, 2008 8:11 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Nested Case statement in Oracle BI
I think you could achieve the same result by using the decode and sign functions, and this could shorten your query a little. Try this: <pre>Select emp_name, decode(sign(emp_hire_date+1825-sysdate),-1,’5 Years of Service Obtained’,to_char(emp_hire_date-sysdate+1825,999999)) TOTAL_DAYS_UNTIL_5_YRS_SERV, decode(sign(emp_hire_date+3650-sysdate),-1,’10 Years of Service Obtained’,to_char(emp_hire_date-sysdate+3650,999999)) TOTAL_DAYS_UNTIL_10_YRS_SERV, decode(sign(emp_hire_date+5475-sysdate),-1,’15 Years of Service Obtained’,to_char(emp_hire_date-sysdate+5475,999999)) TOTAL_DAYS_UNTIL_15_YRS_SERV, decode(sign(emp_hire_date+7300-sysdate),-1,’20 Years of Service Obtained’,to_char(emp_hire_date-sysdate+7300,999999)) TOTAL_DAYS_UNTIL_20_YRS_SERV, decode(sign(emp_hire_date+9125-sysdate),-1,’25 Years of Service [...]
View Answer
| September 30, 2008 7:21 PM
CASE statement, Oracle BI (business intelligence), Oracle SQL
I think you could achieve the same result by using the decode and sign functions, and this could shorten your query a little. Try this: <pre>Select emp_name, decode(sign(emp_hire_date+1825-sysdate),-1,’5 Years of Service Obtained’,to_char(emp_hire_date-sysdate+1825,999999)) TOTAL_DAYS_UNTIL_5_YRS_SERV, decode(sign(emp_hire_date+3650-sysdate),-1,’10 Years of Service Obtained’,to_char(emp_hire_date-sysdate+3650,999999)) TOTAL_DAYS_UNTIL_10_YRS_SERV, decode(sign(emp_hire_date+5475-sysdate),-1,’15 Years of Service Obtained’,to_char(emp_hire_date-sysdate+5475,999999)) TOTAL_DAYS_UNTIL_15_YRS_SERV, decode(sign(emp_hire_date+7300-sysdate),-1,’20 Years of Service Obtained’,to_char(emp_hire_date-sysdate+7300,999999)) TOTAL_DAYS_UNTIL_20_YRS_SERV, decode(sign(emp_hire_date+9125-sysdate),-1,’25 Years of Service [...]
View Answer
| September 30, 2008 7:21 PM
CASE statement, Oracle BI (business intelligence), Oracle SQL
Call Oracle Store Procedure from Reporting services
CREATE OR REPLACE PACKAGE CURSPKG AS TYPE T_CURSOR IS REF CURSOR; PROCEDURE OPEN_TWO_CURSORS (EMPCURSOR OUT T_CURSOR, DEPTCURSOR OUT T_CURSOR); END CURSPKG; CREATE OR REPLACE PACKAGE BODY CURSPKG AS PROCEDURE OPEN_TWO_CURSORS (EMPCURSOR OUT T_CURSOR, DEPTCURSOR OUT T_CURSOR) IS BEGIN OPEN EMPCURSOR FOR SELECT * FROM DEMO.EMPLOYEE; OPEN DEPTCURSOR FOR SELECT * FROM DEMO.DEPARTMENT; END OPEN_TWO_CURSORS; END [...]
View Answer
| September 30, 2008 5:34 PM
Oracle reporting, Oracle stored procedures, REF CURSOR
CREATE OR REPLACE PACKAGE CURSPKG AS TYPE T_CURSOR IS REF CURSOR; PROCEDURE OPEN_TWO_CURSORS (EMPCURSOR OUT T_CURSOR, DEPTCURSOR OUT T_CURSOR); END CURSPKG; CREATE OR REPLACE PACKAGE BODY CURSPKG AS PROCEDURE OPEN_TWO_CURSORS (EMPCURSOR OUT T_CURSOR, DEPTCURSOR OUT T_CURSOR) IS BEGIN OPEN EMPCURSOR FOR SELECT * FROM DEMO.EMPLOYEE; OPEN DEPTCURSOR FOR SELECT * FROM DEMO.DEPARTMENT; END OPEN_TWO_CURSORS; END [...]
View Answer
| September 30, 2008 5:34 PM
Oracle reporting, Oracle stored procedures, REF CURSOR
