Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g imp woes
Andrew Tyson wrote:
> Hi,
>
> I am having some difficulties doing a full import of a database from a
> 10.1.0.2.0 instance running on Win XP to a 10.1.0.2.0 instance running
> on Solaris 10.
>
> The tablespaces have been precreated using the same scripts in each
> case, however during the import I get the following error;
>
> . . importing table "NBI_PRT_FACTS" 3964046 rows imported
> IMP-00017: following statement failed with ORACLE error 1652:
> "CREATE INDEX "NBI_PRT_FACTS_N3" ON "NBI_PRT_FACTS" ("PRJ_OBJECT_ID" ,
The 1652 is the first error - your index creation fails as there is
not enough space in your temp tablespace. I explained that before.
After that, your initial allocation is simply too large - just post
a snippet from your import log with the
PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 262144 FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS_SMALL"
LOGGIN" "G"
bit.
-- Regards, Frank van BortelReceived on Tue Jun 28 2005 - 13:01:51 CDT