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
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
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
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
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
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
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
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
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
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 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 email@example.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
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
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
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
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
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
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
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
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
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