• May 25, 2006 25 May'06

    Using backup taken on Windows to restore Linux database

    I am running a database on Windows and one on Linux. I have taken a backup of the database from the Windows system. Will this backup be utilized to restore the database running on Linux? If yes, can you tell me the procedure?  Continue Reading

  • May 25, 2006 25 May'06

    Creating pipes to export and import large data warehouse

    I have a very large data warehouse database in which I need to do an export and import. The scripts I have seen on the Web are for splitting the .dmp file into several files. What I need is to create multiple pipes to export and import the database....  Continue Reading

  • May 25, 2006 25 May'06

    Header verification failed

    I am using an Oracle dump from Sun Solaris and putting it on a Windows 2003 server. The following error gets generated: "Not a valid export file. Header verification failed." Please let me know what the problem could be.  Continue Reading

  • May 25, 2006 25 May'06

    How many records can I enter?

    If I have a 40GB hard disk and 512MB RAM, and if I install Oracle 9i software on my PC, and if I start inserting records (with five columns), how many records can I enter? I mean, is there any limit for it, or does it depend on the hard disk space? ...  Continue Reading

  • May 24, 2006 24 May'06

    Converting clob to string

    I'm new to Oracle and JDBC. I am using the thin client to retrieve clobs from Oracle 10g using a query. I then want to convert the clob to a string for display. Any sample code out there for me to see how this may be done?  Continue Reading

  • May 24, 2006 24 May'06

    Query to find user who is locking record from rowid

    I have the rowid of a locked record in a specified table in Oracle 10g. I need to know the username of the user locking the record from the rowid that I have. Which query can be used to get such information?  Continue Reading

  • May 24, 2006 24 May'06

    Optimal RAID configuration

    What is the optimal RAID configuration for an Oracle general-purpose database, since you mentioned that RAID 3 and 5 include write issues? What is the best environment? RAID 1 and RAID 5 or what?  Continue Reading

  • May 24, 2006 24 May'06

    Switching to auto space management

    I am operating Oracle 10g. Some of my tablespaces are on manual space management. I want to migrate segment space management from manual to auto.  Continue Reading

  • May 24, 2006 24 May'06

    Getting ORA-12505 when trying to connect to work from home

    I am getting an error message, ORA-12505, saying the SID is wrong. I am trying to connect from home to my place of work. I have mapped drives to orawin95. Does the error reside on my end?  Continue Reading

  • May 24, 2006 24 May'06

    Perl script calling SQL scripts with SQL*Plus

    I have a Perl script that calls several SQL scripts by using SQL*Plus. Whenever there is an error in the SQL script, it returns a value to the Perl that stops the job from running. When the database is down, SQL*Plus does not return any execution ...  Continue Reading