• June 20, 2006 20 Jun'06

    Archive logs file system is exhausted

    This tip explains what to do if the disk file system fills up and the archiver is hung.  Continue Reading

  • June 20, 2006 20 Jun'06

    Archive log not updating

    I have two databases. One is production and the other is standby on the same host. If I do anything committed in the production database, one archive log is created which is automatically transferred to the standby database. But the archive log is ...  Continue Reading

  • June 20, 2006 20 Jun'06

    Tool for migrating data between databases

    I need to migrate some data (maybe insert date on or after a certain date) in ORACLE_DB_1 to another Oracle database ORACLE_DB_2. Is there any tool to do this? After migration, the record will be removed from the ORACLE_DB_1.  Continue Reading

  • June 20, 2006 20 Jun'06

    "Input is too long" error

    Whenever I try to run a certain query in the SQL prompt, it gives the following error: "SP2-0027: Input is too long - line ignored." Please suggest how I can change the default character length so that I am able to run the query.  Continue Reading

  • June 20, 2006 20 Jun'06

    Restricting access to database via trigger

    I'm trying to restrict access to a database via a trigger after logon. When we connect to the database through a tool like SQL*Plus, the name of that program appears in the column "program" of the view v$session. However, I've got a sly end user and...  Continue Reading

  • June 20, 2006 20 Jun'06

    Data truncated after 4,000 characters

    You have given an answer to the following question: "Is it possible to do a UNION of two Oracles 8i views where there are CLOB fields involved?" But I found that the data is getting truncated after 4,000 characters if I follow your suggestion.  Continue Reading

  • June 20, 2006 20 Jun'06

    Protecting *.aud files from SysAdmin

    If the audit_trail init.ora parameter is set to TRUE, Oracle will create a file *.aud in the audit_file_destination directory every time a sysadmin uses the internal command. Sysadmin has write privileges on this file and can update or delete this ...  Continue Reading