How to get started in a SQL Environment
The quickest way would be to download the free version of SQL Server and the Admin tools from Microsoft.com/SQL and start playing with the system to figure out where everything is. There are also dozens of blogs and forums where you can read up. I’d be happy to provide some links if you’d like.
View Answer
| February 12, 2009 9:20 PM
EnterpriseOne, JDE, SQL, SQL Database Training, SQL Server
The quickest way would be to download the free version of SQL Server and the Admin tools from Microsoft.com/SQL and start playing with the system to figure out where everything is. There are also dozens of blogs and forums where you can read up. I’d be happy to provide some links if you’d like.
View Answer
| February 12, 2009 9:20 PM
EnterpriseOne, JDE, SQL, SQL Database Training, SQL Server
New Contest: ASK, Answer and win some Amazon.com gift cards
Good luck everyone. If you have questions email me at sbrooks at techtarget.com
View Answer
| February 12, 2009 4:04 PM
AS/400, CIO, CRM, Data management, Database, DataCenter, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, VMware, VoIP, Windows
Good luck everyone. If you have questions email me at sbrooks at techtarget.com
View Answer
| February 12, 2009 4:04 PM
AS/400, CIO, CRM, Data management, Database, DataCenter, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, VMware, VoIP, Windows
Oracle Reports6 Live Previewer
I don’t know of a setting for that. It could be a compatibility issue.
View Answer
| February 12, 2009 1:49 PM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i Live Previewer
I don’t know of a setting for that. It could be a compatibility issue.
View Answer
| February 12, 2009 1:49 PM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i Live Previewer
How Do I release unused space from a tablespace after dropping a blob table
No i do not think you can. There is no easy way of doing this that is. You can move all of your data out of the tablespace and then drop the tablespace, recreate the table space and then move all of our data back into that tablespace. Oracle does not give an easy way [...]
View Answer
| February 10, 2009 8:50 PM
BLOB, Oracle Tablespaces
No i do not think you can. There is no easy way of doing this that is. You can move all of your data out of the tablespace and then drop the tablespace, recreate the table space and then move all of our data back into that tablespace. Oracle does not give an easy way [...]
View Answer
| February 10, 2009 8:50 PM
BLOB, Oracle Tablespaces
ORA-03113: end-of-file on communication channel
There really is not enough information here to make a good diagnosis. I would suggest that you insert a “set -x” command on the second line of your Unix shell script. This will show you what is being executed as far as Unix is concerned. My suspicion – only a suspicion! – is that there [...]
View Answer
| February 10, 2009 7:12 PM
ORA-03113, Oracle error messages, Oracle SQL, SQL, SQLPlus
There really is not enough information here to make a good diagnosis. I would suggest that you insert a “set -x” command on the second line of your Unix shell script. This will show you what is being executed as far as Unix is concerned. My suspicion – only a suspicion! – is that there [...]
View Answer
| February 10, 2009 7:12 PM
ORA-03113, Oracle error messages, Oracle SQL, SQL, SQLPlus
Does Oracle Stream data replication requires identical tables structure between source and Target Databases?
This is really a question of requirements and possibilities. I am presuming that you have looked over the High Availability and Replication documentation and you are looking for something more flexible. In Streams, there are no explicit constraints for table design or structure. Yes, you can have different PKs in tables of two databases. That [...]
View Answer
| February 10, 2009 7:04 PM
Data Replication, Oracle Stream Data Replication, Oracle Streams, Oracle Table
This is really a question of requirements and possibilities. I am presuming that you have looked over the High Availability and Replication documentation and you are looking for something more flexible. In Streams, there are no explicit constraints for table design or structure. Yes, you can have different PKs in tables of two databases. That [...]
View Answer
| February 10, 2009 7:04 PM
Data Replication, Oracle Stream Data Replication, Oracle Streams, Oracle Table
PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL
Hello Inprise. You asked <a href=”http://itknowledgeexchange.techtarget.com/itanswers/attribute-to-test-not-null-and-can-take-specific-value-instead/”>this similar question</a> yesterday. Could you please tell us if the answer provided was not useful, or your question was misunderstood ? It would be also useful to know why you can’t use the IF – THEN -ENDIF approach. Examples always help. Could you provide some example, or tell us [...]
View Answer
| February 10, 2009 4:37 PM
NOT NULL, NULL, PL/SQL, PL/SQL procedure
Hello Inprise. You asked <a href=”http://itknowledgeexchange.techtarget.com/itanswers/attribute-to-test-not-null-and-can-take-specific-value-instead/”>this similar question</a> yesterday. Could you please tell us if the answer provided was not useful, or your question was misunderstood ? It would be also useful to know why you can’t use the IF – THEN -ENDIF approach. Examples always help. Could you provide some example, or tell us [...]
View Answer
| February 10, 2009 4:37 PM
NOT NULL, NULL, PL/SQL, PL/SQL procedure
PL/SQL – Attribute to test not null and can take specific value instead
I’m not sure if I understand correctly your question. If you want to assign some specific value to a varibale or parameter in PL/SQL when it is null, you could use the NVL function, this way: <pre>l_variable := nvl(l_variable,’-');</pre> If this is not what you meant, please provide more information and examples if possible.
View Answer
| February 9, 2009 3:31 PM
NOT NULL, NULL, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL procedure
I’m not sure if I understand correctly your question. If you want to assign some specific value to a varibale or parameter in PL/SQL when it is null, you could use the NVL function, this way: <pre>l_variable := nvl(l_variable,’-');</pre> If this is not what you meant, please provide more information and examples if possible.
View Answer
| February 9, 2009 3:31 PM
NOT NULL, NULL, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL procedure
PL/SQL – How to make a check whether the attribute is positive or zero
You might want to provide more information about your question. - Is this attribute a database table column ? Do you want to make this check when rows are inserted ? - Is this a local variable, or a procedure parameter ? (you tagged your question ‘PL/SQL Variables’) A simlpe answer would be: <pre>if <variable> [...]
View Answer
| February 9, 2009 2:29 PM
Oracle PL/SQL, PL/SQL, PL/SQL attributes, PL/SQL Variables
You might want to provide more information about your question. - Is this attribute a database table column ? Do you want to make this check when rows are inserted ? - Is this a local variable, or a procedure parameter ? (you tagged your question ‘PL/SQL Variables’) A simlpe answer would be: <pre>if <variable> [...]
View Answer
| February 9, 2009 2:29 PM
Oracle PL/SQL, PL/SQL, PL/SQL attributes, PL/SQL Variables
Errors in Creating Oracle packages
There is more than one error: - Remove the semicolon and add the IS (or AS) and BEGIN keywords after the signature definition of the procedure. - Add the END keyword corresponding to the end of the procedure. This would be the modified script: <pre>CREATE OR REPLACE package body PKG_IMAGEM1 as PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, [...]
View Answer
| February 9, 2009 2:12 PM
Creating Oracle packages, Oracle development, Oracle Package, Oracle SQL
There is more than one error: - Remove the semicolon and add the IS (or AS) and BEGIN keywords after the signature definition of the procedure. - Add the END keyword corresponding to the end of the procedure. This would be the modified script: <pre>CREATE OR REPLACE package body PKG_IMAGEM1 as PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, [...]
View Answer
| February 9, 2009 2:12 PM
Creating Oracle packages, Oracle development, Oracle Package, Oracle SQL
Reports go blank with Oracle 10g using JReport (work perfect with Oracle 9i)
There is probably a message in the JReport log files as to why. My guess would be the URL to the DBMS, the user or the password was changed when you upgraded the DBMS version. Also, be sure JReport is using the latest ojdbc14.jar JDBC driver that supports Oracle 10g. You can always email support@jinfonet.com.
View Answer
| February 5, 2009 5:23 PM
JReport, Oracle 10g import/export, Oracle 9i import/export, Oracle 9i migration, Oracle reporting, Oracle Reports 10g
There is probably a message in the JReport log files as to why. My guess would be the URL to the DBMS, the user or the password was changed when you upgraded the DBMS version. Also, be sure JReport is using the latest ojdbc14.jar JDBC driver that supports Oracle 10g. You can always email support@jinfonet.com.
View Answer
| February 5, 2009 5:23 PM
JReport, Oracle 10g import/export, Oracle 9i import/export, Oracle 9i migration, Oracle reporting, Oracle Reports 10g
PL/SQL error
If the corruption is in the index, then rebuilding the index won’t help, because it will rebuild from itself with the corrupt information. If that is the case you will need to drop the index and create it again. If re-creating the index doesn’t solve the problem, then the corruption may be in the table. [...]
View Answer
| February 5, 2009 2:06 PM
ORA-08102, Oracle development, Oracle error messages, PL/SQL, PL/SQL error messages
If the corruption is in the index, then rebuilding the index won’t help, because it will rebuild from itself with the corrupt information. If that is the case you will need to drop the index and create it again. If re-creating the index doesn’t solve the problem, then the corruption may be in the table. [...]
View Answer
| February 5, 2009 2:06 PM
ORA-08102, Oracle development, Oracle error messages, PL/SQL, PL/SQL error messages
Is my Oracle certification current enough?
You will need to update. Current Oracle version is 11g, and many things have changed since version 8. Have a look at the <a href=”http://www.oracle.com/pls/db111/homepage”>Oracle Database 11g Documentation Library</a>
View Answer
| February 4, 2009 2:42 PM
Oracle 8i, Oracle certifications, Oracle Developer 6i
You will need to update. Current Oracle version is 11g, and many things have changed since version 8. Have a look at the <a href=”http://www.oracle.com/pls/db111/homepage”>Oracle Database 11g Documentation Library</a>
View Answer
| February 4, 2009 2:42 PM
Oracle 8i, Oracle certifications, Oracle Developer 6i
CPU UTILIZATION IS SHOWING 0 IN SAR REPORT
While it would require lot more inputs to correctly identify your bottleneck, here are some suggestions: 1. Apart from sar try iostat to identify disk IO bottlenecks. 2. Use prstat to list all the processes running and how much resource they are consuming. Check the Mem and Paging utilization particularly. 3. Use vmstat and swap [...]
View Answer
| February 4, 2009 4:28 AM
CPU, Oracle 10g, SAP, Solaris
While it would require lot more inputs to correctly identify your bottleneck, here are some suggestions: 1. Apart from sar try iostat to identify disk IO bottlenecks. 2. Use prstat to list all the processes running and how much resource they are consuming. Check the Mem and Paging utilization particularly. 3. Use vmstat and swap [...]
View Answer
| February 4, 2009 4:28 AM
CPU, Oracle 10g, SAP, Solaris
Need help creating a specific Oracle View
Could you please provide some example data and explain how you are dealing with the data in those colums now ? Also, the Oracle version could be useful.
View Answer
| February 3, 2009 6:34 PM
Oracle development, Oracle Nested Tables, Oracle Views, VARCHAR
Could you please provide some example data and explain how you are dealing with the data in those colums now ? Also, the Oracle version could be useful.
View Answer
| February 3, 2009 6:34 PM
Oracle development, Oracle Nested Tables, Oracle Views, VARCHAR
IMP-00069 error on Oracle 8i dump import
If you have checked the characterset, then this could happen if you are using different versions of the import/export utilities. Try exporting the data with the EXPORT utility from the destination machine.
View Answer
| February 3, 2009 6:25 PM
IMP-00069, NCHAR, Oracle 8i, Oracle 8i import/export
If you have checked the characterset, then this could happen if you are using different versions of the import/export utilities. Try exporting the data with the EXPORT utility from the destination machine.
View Answer
| February 3, 2009 6:25 PM
IMP-00069, NCHAR, Oracle 8i, Oracle 8i import/export
Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)
That error usually arises when you try to access a non-existent element on a collection. To debug this, you could place all the code inside the for loop in an if-then-else block to make sure you are referencing only existent elements. Something like this: <pre>for i in g_change_tab.first..g_change_tab.last loop if <b>g_change_tab.exists(i)</b> then select count(*) into [...]
View Answer
| February 2, 2009 8:24 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers
That error usually arises when you try to access a non-existent element on a collection. To debug this, you could place all the code inside the for loop in an if-then-else block to make sure you are referencing only existent elements. Something like this: <pre>for i in g_change_tab.first..g_change_tab.last loop if <b>g_change_tab.exists(i)</b> then select count(*) into [...]
View Answer
| February 2, 2009 8:24 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers
Problem running Oracle Forms 9i
Are you getting some error message when trying to install JInitiator ?
View Answer
| February 2, 2009 8:09 PM
Oracle Form Builder, Oracle Forms 9i, Oracle Jinitiator
Are you getting some error message when trying to install JInitiator ?
View Answer
| February 2, 2009 8:09 PM
Oracle Form Builder, Oracle Forms 9i, Oracle Jinitiator
How to call trigger stored in database using Oracle Forms
You can’t call database triggers directly. You should use a stored procedure instead. You can call stored procedures the same way you do for Forms local procedures. Please provide more information if you need further help.
View Answer
| February 2, 2009 7:55 PM
Oracle development, Oracle Forms, Oracle triggers, Triggers
You can’t call database triggers directly. You should use a stored procedure instead. You can call stored procedures the same way you do for Forms local procedures. Please provide more information if you need further help.
View Answer
| February 2, 2009 7:55 PM
Oracle development, Oracle Forms, Oracle triggers, Triggers
Best practices for migrating Oracle 6i to Oracle 10g
Are you going to migrate your database, or your Developer applications (or both) ? There is no version 6i of Oracle database, so I guess you are talking about Forms. If you are going to migrate the database also, please specify your current database version.
View Answer
| February 2, 2009 7:31 PM
Oracle 10g migration, Oracle 6i upgrade, Oracle migration
Are you going to migrate your database, or your Developer applications (or both) ? There is no version 6i of Oracle database, so I guess you are talking about Forms. If you are going to migrate the database also, please specify your current database version.
View Answer
| February 2, 2009 7:31 PM
Oracle 10g migration, Oracle 6i upgrade, Oracle migration
