Re: Import ora-1658 initial extent size

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 01 Mar 2001 09:33:26 GMT
Message-ID: <3a9e14bf.2206409@news-server>

On Thu, 1 Mar 2001 10:00:44 +0100, "Peter Laursen" <ptl_at_edbgruppen.dk> wrote:

>System: Oracle 8.0.5.2.1/ NT 4.0
>I have an export file done as user sys with full=y and all other parameters
>default, ie compress=y conventional path.
>I need to import this into to an empty database with precreated tablespaces.
>The import must create the users and system data like roles and synonyms.
>The easiest way was to do imp as system with full=y, but I run into
>ora-1658 cannot create initial extent for ... the initial extents given in
>the imp file are to big to fit in the 1G datafiles.
>
>What is the best and most efficient way to import from the given exportfile?
>

destroy=n ?

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu Mar 01 2001 - 03:33:26 CST