Search results for query: *

If you are at 8.1.7.4 then you also have access to the CLOB datatype. Your only other choice at that point would be a LONG but handling text in a LONG is not simple and should be avoided if possible. The CLOB type has a lot more package support for searching and manipulating the text. Also look...

I am looking for a 64 bit ODBC driver to be used on a Win2K/2003 server running SQLserver2000 and replicating data to an Oracle database on a HP-UX box. The Win2K server will probably be Itanium or Opteron(?). Does anyone know of such a driver and where I can get it?

This error appears regularly when running a job on our company file server. After it fails the job moves on to the next node. But why does it fail? Has anyone else experienced this problem? And if so have you fixed it and how?

We've found that a virus checker can get in the way too. You might want to turn off the virus checker on the backup server and optionally turn it off on the source server. Use the pre and post scripting options to make sure it is turned back on as the job finishes. We had this problem on a...

My company is planning a DB upgrade from Oracle 8.1.7.4 to either 9.2 or 10g. I have found hw/sw requirements for 9i but have not been so lucky with the same for 10g. The OTN site is full of white papers and marketing stuff but no manuals. Does anyone know where to find the hw/sw requirements...

Another way would be to reference the environment variables within the SQL section -- sqlplus -s <<EOF ${UID} @${SMISQL_PATH}/agency_comm_bal_rpt.sql ${first_process_date} ${second_process_date} ${prod_line} ${monthid} ${report_heading} EOF This method explicitly puts the spaces in...

You might try this: Have the application which inserts the row which fires the trigger immediately delete the row it just inserted. That way the after insert trigger will have fired and done its work on all the other tables and the row you want deleted will be gone. Don't forget to do a commit...

Two versions of Oracle can use the same listener port number but there can be only one listener on that port. If you need to use a 2nd listener user port 1522, 1530, etc. You should not attempt to run 2 separate listeners on the same port. Strange things are bound to happen. I would use the...

Perhaps you could sweet-talk the DBA into granting that select permission!!! :-)

The easiest way I've found is to execute the following commands: # uptime -- shows how long system has been up # who -r -- show last reboot time Does that help?

Is it possible that the DBA Studio software has been uninstalled? Check the properties of the menu item pointing to Dba Studio. It should be defined as a shortcut. In the shortcut properties it should show the full path to the command that gets executed when you start the program. Make sure it...

If you are the DBA you can remedy your access to v$instance by logging in as SYS and issuing: grant select on v$instance to public; After that any user will be able to see the data in that view.

My alert manager used to login to the e-mail server (exchange 5.5) just fine and I'd get appropriate alerts in my e-mail. Somewhere along the line it stopped working. I try to get it to login again and all I get is 'login failed'. So this prevents me from making any updates to the notifications...

I have a similar situation on a datawarehouse. I have recently set my 13 tables to nologging as reams of archived redo logs were being generated every night. Theoretically, setting those tables to nologging should reduce the amount of redo info generated. I am still collecting data to see if...

Also, to use 64 bit Oracle you must be running the 64 bit version of the O/S.

Is anyone using RMAN and ARCserve to backup the archived redo logs on Unix? How about any other scheme and ARCserve? I am looking for a good way to do this. I currently have ARCserve but not the Oracle client for it. If there is a good way to do this without the client then that would be great...

The general practise is to have one Oracle version per ORACLE_HOME location. If your intent is to have 8.1.7.3 and 8.1.7.4 both on the system at the same time then you should create an ORACLE_HOME filestructure for each, eg., /u01/product/oracle/8.1.7.3 and /u01/product/oracle/8.1.7.4 Then...

Thank you all for your input to this. I didn't realize I was opening such a big discussion. At any rate, my problem was solved by the responses that said to move the cursor over the auto-complete value and hit Delete. As to where this is kept, I am beginning to think that it is kept in...

Those little fill-in fields on the search engines have an auto-fill capability that I found out how to turn off in MSIE. But I have not found out how to delete all the entries in the auto-fill &quot;dictionary&quot;. Is there a way to do that? After a while it pops-up too long a list to be very...