DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RBS growing

  1. #1
    Join Date
    Apr 2001
    Posts
    126

    Unhappy RBS growing

    my RBS tablespace is growing.. i alloted only 500 MB , but after i import the data it grows more than 1 GB now.. why it is growing? i have not referred any tables / indexes for RBS.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    What do you mean you haven't refered any tables or indexes to RBS?

    Any changes you make (including imports) will need to generate rollback so it if your objects are suffiencently large enough the RBS segments will grow to accomodate the import unless you use commit=y

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    and its growing cos u must have set autoextend on on the rbs datafile...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Apr 2001
    Posts
    126
    Thanks a lot.

Posting Permissions

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


Click Here to Expand Forum to Full Width