Re: Getting information out of dumpf-file

Hi,

I think you have possibly a problem because the export was done with option COMPRESS=Y (default behaviour). With this option the tables are compressed into one single extent - the initial extent, i.e. if table BLA has 200 extents with 20M in the source database, you will have an initial extent of 4000M in the destination database. To create this table in target you need at least 4000M freespace in one single datafile (NOT tablespace).

What you can do is to check the export using imp with option INDEXFILE=Y, i.e.:
imp userid=<user>/<passwd> rows=n indexes=n file=<your dump file> full=y indexfile=<your new indexfile>
The above statement creates an indexfile which contains all sql statements which are carried out during the import.

Please check the output for INITIAL and TABLESPACE (in storage clause of sqls) and check if you have enough space in datafiles of given tablespaces .

regards
Hartmut

"Daniel Cloutier" <danielcloutier_at_web.de> schrieb im Newsbeitrag news:3c0f4d66$1_at_netnews.web.de...
> Hello everybody!
>
>
> We´re having quite a problem with our Oracle 8i database. One of our
clients
> sent us a dump file on CD and we use that file to update our database,
which thus
> is an exact copy of that client´s database. Now, we´re just getting errors
when
> we start the import of that dump file which is ORA-1658 Cannot create
INITIAL-
> EXTEND in Tablespace ABC (the only error but appears a dozen times). I
looked up
> the error code and my Oracle book said, that there's no sufficient
diskspace
> available. So we put another 40 GB HD in our server and copied the whole
database
> on this new partition (same drive letter). Now, we still get this error.
All
> other updates so far, worked fine. Diskspace was about 8 GB and it worked
on that
> partition. Now there´s over 20 GB of free diskspace and that should
definately do
> it.
>
>
> Now, I have the follwoing questions (assuming that the problem still is
> diskspace):
>
>
> 1. Can I somehow retrieve information out of the dumpfile, what settings
are
> applied for a certain table? Let´s say, dumpfile contains a table
"Customers",
> can I get the information what the initial extend for this table is?
>
>
> 2. If I can get the information, can I change it in such a way, so it will
fit
> on our HD?
>
>
> 3. Am I totally wrong and is there an other way to fix that problem?
>
>
> Would be nice, if someone can help me out here!
>
>
> Thanks in advance!
>
>
> Bye,
> Joerg
>
> --
> __________________________________________________________
> News suchen, lesen, schreiben mit http://newsgroups.web.de
Received on Thu Dec 06 2001 - 07:49:24 CST