• May 25, 2006 25 May'06

    Enterprise Manager not showing export database option

    I've been working on exporting my database. The Enterprise Manager only shows me two options: export tables or export schema. It doesn't show me the export database option. Also, while exporting tables, I am only able to select tables in the SYSTEM ...  Continue Reading

  • 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

    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

    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

    Scheduling automatic RMAN backups

    We have configured RMAN at our organization and we want to automatically schedule an RMAN backup every day at 5:00 a.m. Is there is any procedure or command to schedule our RMAN backups automatically?  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 25, 2006 25 May'06

    Header error during import

    I am getting a header error while importing exported data from one server to another server.  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

    Multiple nodes without RAC

    Is there any reason that you should NOT employ a shared Oracle home when you have multiple nodes and a cluster filesystem (and you do NOT use RAC)? How does Oracle protect itself from starting two non-cluster-aware instances on two different nodes? ...  Continue Reading