Import problem

From: <tzagara_at_leena.cti.gr>
Date: 7 JUL 94 20:51:39 GMT
Message-ID: <7JUL94.20513912_at_leena.cti.gr>


Hi there,

I have the following problem:

Someone sent to me two ORACLE .dmp files. These files were created during an export of an ORACLE V6.0.34.2.1 database on a HP9000/832 running HP-UX rev 9.0.

Now I want to import these two files on a ORACLE V7.0 database.

During the import of the first file, no error occured. But, when I tried to import the second file, a message appeared saying, that the tablespace is not enough. So, I created a new tablespace using the following command:

   create tablespace tabspace_2
   datafile 'tabspace_file2.dat' size 20m    default storage (
   initial 10k next 50k
   minextents 10k maxextents 999
   pctincrease 10
   )
   online

But now, when I start the import, the following message appeares:

ORA-02226:invalid MAXEXTENTs value (max allowed 121)

(from what I saw in the .dmp files, this value is 999 ).

Any help is welcome.
Thanks in advance.

_at_@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

                                    e-mail:
Emmanuel Tzangarakis,                tzagara_at_cti.gr
Computer Technology Institute (CTI) tzagara_at_grpatvx1.bitnet Patras
Greece

_at_@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Received on Thu Jul 07 1994 - 22:51:39 CEST

Original text of this message