Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: Rogbaker@gdi.net (Rogbaker) Newsgroups: comp.databases.oracle.misc Subject: Re: Unlimted Extents = 505? Date: 12 Dec 2002 10:42:15 -0800 Organization: http://groups.google.com/ Lines: 14 Message-ID: References: NNTP-Posting-Host: 169.139.180.100 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1039718536 16024 127.0.0.1 (12 Dec 2002 18:42:16 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 12 Dec 2002 18:42:16 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90483 X-Received-Date: Thu, 12 Dec 2002 11:53:27 MST (news.easynews.com) 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'. >