Import full oracle 8.1.7
From: eliot06 <p.hirth_at_gmail.com>
Date: Mon, 9 May 2011 10:56:14 -0700 (PDT)
Message-ID: <8830cecb-8c39-4703-b38f-ff8ecf32a120_at_dn9g2000vbb.googlegroups.com>
Hello, I just accidentally deleted a database Oracle 8.1.7.4. I have a full export.
"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 "
"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 Received on Mon May 09 2011 - 12:56:14 CDT
Date: Mon, 9 May 2011 10:56:14 -0700 (PDT)
Message-ID: <8830cecb-8c39-4703-b38f-ff8ecf32a120_at_dn9g2000vbb.googlegroups.com>
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 Received on Mon May 09 2011 - 12:56:14 CDT