• 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 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

    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

    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 30, 2005 30 Aug'05

    ORA-01092 error while using DBCA

    While using DBCA to set up a new database, the ORA-01092 error appeared. The operating system that I use is Red Hat Linux 8.0. The database system is Oracle9i.  Continue Reading

  • August 30, 2005 30 Aug'05

    Migrating from Solaris to Linux

    We need to migrate our Oracle 9.2 database from Sun Solaris to Red Hat Linux. Our datafiles are stored on EMC's SAN. Do we have to use export and import even though we use a centralized storage?  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

    Installing 9i on Windows XP

    Please provide me with complete steps on how to install 9i on Windows XP. In fact I tried, but the database is not opening.  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

    Error in ODBC connections

    Using Oracle 9i, Windows 2000 SP4. I'm installing an Oracle client and getting an error in ODBC connections when trying to test the connection.  Continue Reading

  • August 30, 2005 30 Aug'05

    ORA-12545 error when connecting to database via client

    I loaded Oracle 9i Client on my machine, where I also have Oracle 8. I am able to connect to the database using the Oracle 8 client (SQL prompt), and I want to connect to the database using the Oracle 9i client. I get an ORA-12545 error.  Continue Reading

  • August 29, 2005 29 Aug'05

    Input truncated to one character

    When executing SQL or PL/SQL programs a message like "input truncated to one character" is displayed. What is that?  Continue Reading

  • August 28, 2005 28 Aug'05

    Oracle apps DBA interview questions

    Naveen Nahata of OAUG provides this list of interview questions he typically asks of aspiring Oracle applications DBAs.  Continue Reading

  • August 26, 2005 26 Aug'05

    Difference between E-Business Suite 11.5.6 and 11.5.9

    Is there any document that can give me the difference between Oracle E-Business Suite release 11.5.6 vs. 11.5.9?  Continue Reading

  • August 25, 2005 25 Aug'05

    Identifying the source of high CPU usage

    We are currently using E-Business Suite 11.5.7 on a single-node installation, with db and apps on the same node. When we detect a high CPU usage with a glance, it's difficult to find out what is the offending process. How can I identify a financials...  Continue Reading

  • August 24, 2005 24 Aug'05

    RMA authorization numbers

    I need to enter RMA authorization numbers that are generated in another system to Oracle inventory so that I can receive against them. We don't use Order Management or AR. The MTL_SO_RMA_INTERFACE table seems to be the place to go but I'm not sure...  Continue Reading

  • August 22, 2005 22 Aug'05

    Database crash during hot backup

    Our Oracle 8.0.4 database crashed while doing a hot backup with CA BrightStor. Now one of our databases will not start. Event viewer shows it starting and then shutting down again. Our dbaora7.log shows that all tables and control files ...  Continue Reading

  • August 22, 2005 22 Aug'05

    RMAN commands for Oracle 8i

    I have created an RMAN catalog database ( and have registered a target db ( I did this mostly with information from a 9i RMAN book and the web, which is mostly 9i and 10g info. I can connect to the catalog and the target from ...  Continue Reading