Title: RE: dbms_sql from stored procedure
Sarath,
Go locally managed tablespace and forget about extent management. It's just not worth it.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Ori
dear list,
i am inserting 90 million rows into a table using a
stored procedure. i have a rough estimate of space
16270M. i dont want to add datafiles to this
tablespace since i dont do any more inserts after
this.
i created an intial of 250M and next of 250M
after grabbing 62 extents it could n