Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: exp/imp and extents

Re: exp/imp and extents

From: koert54 <nospam_at_spam.com>
Date: Sun, 04 Apr 2004 11:49:30 GMT
Message-ID: <eDSbc.12302099$Id.2055630@news.easynews.com>


Another tip : use a pretty printer that can replace the storage clause : http://sourceforge.net/projects/pretoria http://pretoria.sourceforge.net/

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0403231324.78dc5b51_at_posting.google.com...
> richchri_at_erols.com (richie) wrote in message
news:<9a436674.0403230635.3b4ea9eb_at_posting.google.com>...
> > Wow thanks for all the responses. I did indeed did not use the
> > compress option which would default to Y. I had thought that option
> > was just to use some sort of oracle proprietary compression while
> > exporting to the dmp file inorder to save some space and be able to
> > deal with larger dmp sizes. I do generally set compress=n just to be
> > on the safe side and lessen the amount of things that could go wrong.
> > However, in this case I was just doing a quick move of an empty table
> > and figured since I wasn't exporting the data with rows=n there was no
> > real data I would have to worry about loosing and it wouldn't hurt
> > any. I had no idea about the extent allocation. You learn something
> > new everyday.
>
> 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
>
> jg
> --
> @home.com is bogus.
> http://cgi.cs.indiana.edu/~oracle/index.cgi
Received on Sun Apr 04 2004 - 06:49:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US