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 -> Getting information out of dumpf-file

Getting information out of dumpf-file

From: Daniel Cloutier <danielcloutier_at_web.de>
Date: 06 Dec 2001 11:50:14 +0200
Message-ID: <3c0f4d66$1@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 INITIALEXTEND  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 - 03:50:14 CST

Original text of this message

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