Re: Import full oracle 8.1.7

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 10 May 2011 20:41:21 +1000
Message-ID: <iqb4oc$bm$1_at_dont-email.me>



eliot06 wrote,on my timestamp of 10/05/2011 3:56 AM:
> 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

Did you create a basic database instance with SYSTEM tablespace before starting the import? It needs it.
Otherwise you get these "no data found" and "invalid create" errors: there is no dictionary to add-on to. Received on Tue May 10 2011 - 05:41:21 CDT

Original text of this message