Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    1

    Unanswered: Table space segment increased by 90% over night...please help

    Hello - I appended data from Access to Oracle last night and all of the sudden, the database size went from 40% to 91%. My segment size is 120mb - what did I do wrong? I only inserted 460 rows and most of them are chars of 10 or less.

    Please help...

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Ouigi board?

    Hmmmm, my crystal ball is in the shop being repaired now, so my guess is as good as yours.

    If you are using WinDoze, maybe you should use the standard fix: re-boot.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2009
    Posts
    44
    Quote Originally Posted by wsonbol
    Hello - I appended data from Access to Oracle last night and all of the sudden, the database size went from 40% to 91%. My segment size is 120mb - what did I do wrong? I only inserted 460 rows and most of them are chars of 10 or less.

    Please help...
    Gather statistics and see which objects are taking up all the space.

    You'll have to tell us what tools you have available to help you more: enterprise manager, sql developer or just sqlplus.

Posting Permissions

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