Re: Import full oracle 8.1.7

From: eliot06 <p.hirth_at_gmail.com>
Date: Mon, 9 May 2011 12:37:50 -0700 (PDT)
Message-ID: <0dc82f17-1666-406c-9871-123cf44c48bd_at_o8g2000prf.googlegroups.com>

On 9 mai, 21:26, ddf <orat..._at_msn.com> wrote:
> On May 9, 10:56 am, eliot06 <p.hi..._at_gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > Hello, I just accidentally deleted a database Oracle 8.1.7.4.
> > I have a full export.
>
> > and when I do full import I have lots of error like below :
>
> > IMP-00017: following statement failed with ORACLE error 901:
> > "CREATE TEMPORARY TEMPFILE '/oradata/MVSTST/temp01.dbf' S"
> > "IZE 891289600 AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M EXTENT MAN"
> > "AGEMENT LOCAL UNIFORM SIZE 1048576"
> > IMP-00003: ORACLE error 901 encountered
> > ORA-00901: invalid CREATE command
> > IMP-00017: following statement failed with ORACLE error 1403:
> > "CREATE TABLESPACE "TBSI_77" DATAFILE '/oraindx/MVSTST/TBSI_77.dbf'
> > SIZE 13"
> > "5266304 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M EXTENT MANAGEMENT "
> > "LOCAL USER DEFAULT STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 "
> > " PCTINCREASE 0) MINIMUM EXTENT 65536 "
> > IMP-00003: ORACLE error 1403 encountered
> > ORA-01403: no data found
> > IMP-00017: following statement failed with ORACLE error 1403:
> > "CREATE TABLESPACE "TBSI_37" DATAFILE '/oraindx/MVSTST/TBSI_37.dbf'
> > SIZE 62"
> > "914560 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M EXTENT MANAGEMENT L"
> > "OCAL USER DEFAULT STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 "
> > " PCTINCREASE 0)"
>
> > thanks
>
> Are you attempting to import this into a fresh 8.1.7.4 database?  Post
> exactly what you're doing to get these errors.
>
> David Fitzjarrell

I was Wrong!!! is not a 8.1.7.4 but is a 8.1.7.2 Received on Mon May 09 2011 - 14:37:50 CDT