Xref: alice comp.databases.oracle.server:56878 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!dispose.news.demon.net!demon!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: How it works alter tablespace X default Storage...? Date: Mon, 12 Jul 1999 07:07:00 +0200 Message-ID: <931755985.12449.0.pluto.d4ee154e@news.demon.nl> References: Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 931755985 pluto:12449 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 53 Trying to understand your post, it seems to be a bit confused 1 altering the default storage clause will apply to NEW objects only. No existing objects are changed. 2 If you want to change existing objects, initial cannot be changed, next can be changed. However, this needs to be done object by object (or by means of a script) 3 if you do want to change initial, you need to export everything in that tablespace, drop the current objects, create them with the correct sizing and import the file you exported. Hth, Sybrand Bakker, Oracle DBA Huy Vu wrote in message news:iCdi3.10548$jl.17088182@newscontent-01.sprint.ca... > Hi all, > > I did the command > > Alter tablespace tbsA > default storage > ( initial 1M > next 512K > pctincrease 0 > minextents 1 > ); > > to fix the old value of tabsA > > default storage > ( initial 4K > next 4K > pctincrease 0 > minextents 1 > ); > > but I still not finger out how it change inside the tablespace tbsA > Do I need to backup the tablespace before executing this command ? > > The same question for resizing the tablespace... > But how can we know the current value INITIAL & NEXT using in the > tablespace? > > > Thanks in advance for any idea... > > H.V > > >