Search results for query: *

Great, email to jamesgaines@adelphia.net Thanks.

you can set the default system wide format in the init.ora file nls_date_format= mm/dd/yyyy. I belive you can also set this in the session profile too, glogin.sql, the format is a little different.

I recently had problems with my FC60 controller and was trying to decode the sequence of lights but could not find any specific information on doing so in the user's guide or advanced user's guide. Where can I find a service manual? I have search on HP's website and could not find one!

You can also get the instance startup time from v$instance select startup_time from v$instance;

Try and use direct path loading with sql loader. set DIRECT=true on the command line or in your par file. http://www.orafaq.com/faqloadr.htm#SPEED Can one improve the performance of SQL*Loader? A very simple but easily overlooked hint is not to have any indexes and/or constraints (primary key)...

Delete does not change the High water mark in the table, so you would not see the improvements. export the table, truncate, import the table.

Oracle imp is upwards compatible, but not downward compatible. One solution that I have used before is to run the exp command on your 8.1.5 instance to extract the data from the 8.1.6 database, just add an entry to your tnsnames.ora file and connect remotley. If this is not an option you could...