Re: exp/imp and extents

Another tip...

For 9i and up, I always use the dbms_metadata package to get the DDL for a table. Here's an example if you haven't used it...

/* I don't remember which of these you actually need. I have them in my login.sql file */

sql> set long 1000000
sql> set trimspool on
sql> set heading off
sql> set linesize 200
sql> select dbms_metadata.get_ddl('TABLE', 'TABLE_NAME') from dual;

Here' a quick link to some info on Don Burleson's website...

http://www.dba-oracle.com/art_builder_get_schema_syntax.htm

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

joel-garry_at_home.com (Joel Garry) 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
Received on Wed Mar 24 2004 - 10:23:41 CST