Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jmannix
  • Content: Threads
  • Order by date
  1. jmannix

    chunk fails sanity check, instance won't come online

    I have Informix 9.4 running on Solaris. Earlier in the week a hard drive failed. The drive has been replaced. Two of the slices on the disk were mirrored and the mirrored slices have been recovered. However I discovered one of the slices was not mirrored, and appears to be a slice holding...
  2. jmannix

    Oracle heterogeneous services using generic connectivity

    We are running Oracle 8.1.7 on a UNIX machine and would like to connect to MS SQL Server 2000 on a MS box. While reviewing Oracle's documentation we can't conclusively determine if we need additional software or not. Again we want to use generic connectivity with Oracle's heterogeneous...
  3. jmannix

    formatting output from SELECT *

    I get frustrated when I select all fields from a large table and the column headings and values wrap across many lines. I usually perform this task on a few rows to get an idea of what values are in the fields when I am unfamilar with the information stored in the table. Does anyone have a...
  4. jmannix

    changing a fieldname

    I'd like to be able to change the name of a field that I added to a table. I know I can't delete and add a new one back, so I am hoping there is a way to re-name. Any help is appreciated. Thanks in advance.
  5. jmannix

    Optimizing Oracle queries

    Does anyone know if the order by which you place clauses in the WHERE section of a query can improve the performance of a SQL statement? Thanks, Joe
  6. jmannix

    using dbms_output

    I use dbms_output.put_line and dbms_output.put to spool output. However it seems that these funtions do not like beginning spaces, otherwise I can not use dbms_output.put_line(' This is a line of text to be centered"); I have been able to insert a tab char before any spaces and get...

Part and Inventory Search

Back
Top