Re: Export without STORAGE clause ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 03 Feb 2000 20:29:44 +0800
Message-ID: <389974B8.5D9B@yahoo.com>

Jarek Palka wrote:
>
> I'd like export whole schema WITHOUT storage clause in dump file.
> Is it possible?
> There are large initial extents in source database but I don't want have
> large INITIAL extents in new schema ie:
>
> CREATE TABLE .... STORAGE (INITIAL 12345678 NEXT 654321 ...
> CREATE INDEX .... STORAGE (INITIAL 12345678 NEXT 654321 ...
> ____________________________________________________________
> Jarosław Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice
> tel. (+48 32) 255-59-93, 209-07-05, fax 209-07-15 POLAND

Use compress=n for starters

Another option is:

1. exp rows=n
2. strings expdat.dmp > expdat.sql
3. sed 's/STORAGE(.*)//g' expdat.sql > newexpdat.sql

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Feb 03 2000 - 06:29:44 CST