Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Unanswered: Indexing Problem

    hi all,

    oracle 9i windows version

    I use file system document store. Every 1 hour I synchronize
    index (sync_index), and every 5 hour I optimize the
    Index (OPTIMIZE_INDEX),
    at this time it is unable to delete
    the file physically from the harddisk.


    1. Is there anyway to delete the file from hard disk
    while in index?
    2. Is there a way to findout if the rebuild of index
    is over?

    Thank you.

    cheers
    sam

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you shouldn't need to do any of this.
    Oracle does this for you behind the scenes as you add/remove data.

    Why do you feel you need to manually manage the indexes on the table(s)?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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