Re: Oracle 9i IMP error

From: <frank.van.bortel_at_gmail.com>
Date: 23 Jan 2007 03:46:18 -0800
Message-ID: <1169552778.251007.277820@s48g2000cws.googlegroups.com>

joy schreef:
> Here is the text of the error message thrown:
>
> . importing SYSTEM's objects into SYSTEM
> IMP-00017: following statement failed with ORACLE error 3214:
> "CREATE TABLESPACE "SFMS_BR_DATA" BLOCKSIZE 8192 DATAFILE
> 'F:\SFMS_BRANCH\O"
> "RADATA\SFMS\SFMS_DATA1.DBF' SIZE 3480 EXTENT MANAGEMENT LOCAL
> AUTOAL"
> "LOCATE ONLINE PERMANENT NOLOGGING"
> IMP-00003: ORACLE error 3214 encountered
>

Looks to me, imp is trying to create tablespace SFMS_BR_DATA, but there already is a datafile present. Received on Tue Jan 23 2007 - 05:46:18 CST