Re: exp/imp and extents

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