skip to main | skip to sidebar

Oracle in examples.

Oracle in examples.

Thursday, July 3, 2008

ORACLE TECHNIQUES

  • How to clean up the FRA from archive logs.
  • How to create a flash recovery area.
  • ORA-06512 on 9i SE
  • How to reset an oracle parameter.
  • "EXP-00008: ORACLE error 6550 encountered" error of Oracle10g.
  • How to truncate all tables in schema which contain foreign key constraints.
  • How to import a schema and ignore all data from tables.
  • How to change the location of oraInventory.
  • How to switch a database into the archive log mode.
  • How to analyze all tables with theirs indices where statistics is equal to null.
  • How to rebuild a table which occupies the last extend in the data file, and then shrink this file.
Posted by Sergey at 7:43 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Sergey
View my complete profile

Blog Archive

  • ▼  2008 (21)
    • ▼  July (10)
      • Ubuntu under VMware.
      • Oracle Identity Management And Internet Directory.
      • $ORACLE_HOME/(server_dbname)/sysman/recv/errors di...
      • How to rebuild a table which occupies the last ext...
      • How to analyze all tables with theirs indices wher...
      • How to make a crontab backup.
      • How to switch a database into the archive log mode:
      • MISCELLANEOUS
      • ORACLE TECHNIQUES
      • INSTALLATION
    • ►  May (2)
    • ►  April (4)
    • ►  March (5)
  • ►  2007 (2)
    • ►  December (1)
    • ►  November (1)

CONTENTS

  • INSTALLATION
  • ORACLE TECHNIQUES
  • Oracle Identity Management And Internet Directory
  • MISCELLANEOUS

My favourite oracle links:

  • Oracle-base
  • Become Apps DBA