To check the space simply use select * from dba_free_space where
tablespace_name = <your TS> order by bytes;
"Hartmut Göhrt" <goehrt_at_t-online.de> schrieb im Newsbeitrag
news:9unt26$dk1$02$1_at_news.t-online.com...
> 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:55:22 CST
