Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    1

    Question Unanswered: Oracle 8i fine tuning

    HI,
    i have known MS ACCESS databases to be compacted and repaired...
    I would like to know how can thios be done for an oracle 8i databases

    Thanks and regards,
    Nikhil

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    You cannot 'compact' or 'repair' Oracle databases.
    You could re-organise the database by making an export, dropping all tables, recreating all tables with better storage and then re-import the data. But that's a time consuming action.
    What also helps is rebuilding the indexes.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •