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: Joel Garry <joel-garry_at_home.com>
Date: 23 Mar 2004 13:24:05 -0800
Message-ID: <91884734.0403231324.78dc5b51@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 Tue Mar 23 2004 - 15:24:05 CST

Original text of this message

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