Re: Oracle 9i IMP error

From: joy <joydeepu_at_gmail.com>
Date: 22 Jan 2007 22:08:42 -0800
Message-ID: <1169532522.388750.117190@l53g2000cwa.googlegroups.com>

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

DA Morgan wrote:
> joy wrote:
> > I'm trying to import a 9i schema using the command :
> > imp gw/sfm_at_sfm file=F:\gw_backup.dmp ignore=yes log=imp_backup.log
> > full=y
> > All tablespaces and tables have been precreated in the target database.
> > IMP throws up the following error:
> >
> > IMP-00003: ORACLE error 3214 encountered
> > ORA-03214: File Size specified is smaller than minimum
> > required"
> > Can someone please tell me how to get over this problem.
> > Thanks
> > Joy

>

> And the file size is?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Tue Jan 23 2007 - 00:08:42 CST