Newsgroups: comp.databases.oracle.server Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.glorb.com!meganewsservers.com!feeder2.on.meganewsservers.com!newshosting.com!nx02.iad01.newshosting.com!news-feed01.roc.ny.frontiernet.net!nntp.frontiernet.net!tdsnet-transit!newspeer.tds.net!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: exp/imp and extents X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <4060B7F8.EDB26E1D@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: <9a436674.0403221145.85ec3ea@posting.google.com> <9a436674.0403230635.3b4ea9eb@posting.google.com> <91884734.0403231324.78dc5b51@posting.google.com> Mime-Version: 1.0 Date: Tue, 23 Mar 2004 22:19:36 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 31 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:257876 > Here's another educational trick: > > use the unix strings command on the export file and grep the result > for the table name, or maybe the string CREATE TABLE. > > strings expdat.dmp |grep "CREATE TABLE"|more Or use the INDEXFILE option of the imp utility to create a DDL script. Then using this information, precreate the table with an appropriate INITIAL and NEXT. Then import with IGNORE=Y. Personally, I like to upgrade to LMTs and start living!!! Cheers, Brian -- =================================================================== Brian Peasland dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"