• August 31, 2005 31 Aug'05

    Installing a composite primary key on a column without unique data

    I was wondering if I could install a composite primary key on a table which does not have unique data on one of the columns. When I try to install a composite primary key using that column, obviously it blows up. Is there a workaround other than ...  Continue Reading

  • August 31, 2005 31 Aug'05

    Input/output errors

    I have the following error:

    ERROR at line 1:
    ORA-01115: IO error reading block from file 2 (block # 2772)
    ORA-01110: data file 2: '/home5/oracle/oradata/lrec_ts_files/lrec.dbf'
    ORA-27091: skgfqio: unable to queue I/O
    ORA-27072: skgfdisp: I...
    				 Continue Reading

  • August 31, 2005 31 Aug'05

    Technical considerations for using NUMBER vs. VARCHAR2

    My question is a continuation of the NUMBER/VARCHAR2 question. You have given functional considerations in your answer. Are there any technical considerations, things like speed of data manipulation or space considerations?  Continue Reading

  • August 31, 2005 31 Aug'05

    Ways to speed up a full export

    I have a database exclusively for ESRI SDE consisting mainly of imagery (approximately 2 terabytes and growing). Currently a full expdp takes 12+ hours. Are there any possible parameters and/or options to expedite a full expdp in a shorter timeframe?  Continue Reading

  • August 31, 2005 31 Aug'05

    Using OS Authentication

    I believe that we have a configuration somewhere (Oracle?) that allows Unix user account "ORAsid" to connect to the database as "OPS$ORAsid" without requiring a password. Is this true? Could this be changed (to requiring a password to get into the ...  Continue Reading

  • August 31, 2005 31 Aug'05

    Converting from CHAR to DATE datatype

    As a time value, I used the CHAR datatype and need to convert to a DATE value while manipulating/computing. How do I use the DATE datatype instead?  Continue Reading

  • August 31, 2005 31 Aug'05

    Design recommendations for FACT TABLE and DIMENSIONS

    We are in the phase of warehouse designing. What are the recommendations and restrictions for FACT TABLE and DIMENSIONS?  Continue Reading

  • August 30, 2005 30 Aug'05

    Fatal NI connect error

    I have the following error in my Oracle server: "Fatal NI connect error 12638." I don't understood why because it was working so well before, but today it sent that error.  Continue Reading

  • August 30, 2005 30 Aug'05

    Best approach for upgrading from 8i to 10g

    Later this year we will be undertaking upgrades for a client from Oracle 8i to Oracle 10g on Solaris platforms. Can you advise us on what components of Oracle 10g and IAS we need to install as a minimum, as well as the best approach for upgrading?  Continue Reading

  • August 30, 2005 30 Aug'05

    Downloading Oracle for Windows 2003 Enterprise Server

    I've downloaded Oracle 9i release 2 from the Oracle site but it refused to install on my new Windows 2003 server box. Could you please give me the exact address so I can download the Oracle database which can be installed on Windows 2003 Enterprise ...  Continue Reading