• 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

    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

    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

    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

    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

    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

    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

    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