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.
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
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!
and its growing cos u must have set autoextend on on the rbs datafile...
"There is a difference between knowing the path and walking the path."
Click Here to Expand Forum to Full Width