Recent content by ScottAB

Yes. We have seen documentation that states we can do this by issuing the SQL statement: ALTER TABLE tableName MODIFY (longColumnName CLOB);

I recently installed Oracle9i Application Server (1.0.2.0.1) on our Sun Solaris (8) system. All is good except for the fact that our legacy application cannot "talk" to our new 9i database because of the LONG vs CLOB datatype issues. We are in the process of writing conversion scripts...

I received an Oracle export today that was suffixed with a .Z. No problem; it's compressed using the compress command. However, when I go to uncompress it, I receive an error saying "corrupt input", and the process fails. I called the person I received the export from and he...

How do I find the owner of objects in a database? I want to remove a particular user from one database but I can't because this user owns some objects. I want to change the ownership of these objects and then remove the user. Does this sound valid?

Yes, we are running Oracle 7.3.4.5, 8.1.5, and 8.1.7 on this box.

Will changing this parameter require a reboot?

We are running an application written in Forte that runs slower while compiled on our HP-UX 11.00 box than it does in interpretive mode under Windows! This just doesn't seem possible so we are looking into fine-tuning how Forte / HP-UX should be configured. One item we found is to use the ndd...