Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!feeder2.on.meganewsservers.com!meganewsservers.com!textfeed1.on.meganewsservers.com!gail.ripco.com!tdsnet-transit!newspeer.tds.net!news-out.news.tds.net!sn-xit-03!sn-xit-12!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: resetting initial_extents Date: Thu, 05 May 2005 12:01:37 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 20 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:118877 On Thu, 05 May 2005 06:07:30 GMT, "Randy Harris" wrote: >Is there any method of resetting storage parameters on a bunch of tables? >Perhaps something with exp/imp that would recreate the tables with the >default storage parameters? Some procedure that would retain data, >constraints and grants. > imp doesn't recreate any tables if they already exists. It either errors out, or ignores the errors. You'll need to drop the tables and recreate them manually prior to import. If you don't have your create table scripts, you can generate them from imp by using show=y log= and possibly edit by removing extent definitions. -- Sybrand Bakker, Senior Oracle DBA