Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!msc1.onvoy!onvoy.com!news.state.mn.us!not-for-mail From: TurkBear Newsgroups: comp.databases.oracle.misc Subject: Re: Unlimted Extents = 505? Date: Thu, 12 Dec 2002 13:55:29 -0600 Organization: Minnesota Governmental/Educational Agencies Lines: 21 Message-ID: References: Reply-To: johng@mm.nospam.com NNTP-Posting-Host: gateway.dot.state.mn.us Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.state.mn.us 1039722932 10935 156.98.4.11 (12 Dec 2002 19:55:32 GMT) X-Complaints-To: news@news.state.mn.us NNTP-Posting-Date: Thu, 12 Dec 2002 19:55:32 +0000 (UTC) X-Newsreader: Forte Agent 1.8/32.548 Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90487 X-Received-Date: Thu, 12 Dec 2002 12:55:07 MST (news.easynews.com) One other point - if you do not specify the storage details in the create table statement, the tablespace's settings will be used. Rogbaker@gdi.net (Rogbaker) wrote: >Magpies, >I am not sure I follow. Since I dropped the tables, there were no >existing settings. I expected to have the same settings of the tables >I exported/imported. >-Roger > > >"magpies" <-_-> wrote in message news:... >> You can just to truncate the tables but to drop it out. Otherwise, import >> will create a new table based on its original setting. >> Now you can truncate the tables again, set the table at apporiate value >> using 'alter table' command. Lastly, import the tables using 'import table' >> option instead of 'full import'. >>