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

On May 9, 10:56*am, eliot06 <p.hi... (AT) gmail (DOT) com> wrote:
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

On 9 mai, 21:26, ddf <orat... (AT) msn (DOT) com> wrote:
I import into a 8.1.7.2 database !!

On 9 mai, 21:26, ddf <orat... (AT) msn (DOT) com> wrote:
I was Wrong!!! is not a 8.1.7.4 but is a 8.1.7.2

On 9 mai, 21:37, eliot06 <p.hi... (AT) gmail (DOT) com> wrote:
exactly i execute : imp system/whenever file=expfull.dmp full=y rows=y
log=impfulmvstst.log ignore=y

On Mon, 09 May 2011 12:36:12 -0700, eliot06 wrote:


Did someone set up you the bomb? You should turn the main screen on.



--
http://mgogala.byethost5.com

On May 9, 1:56*pm, eliot06 <p.hi... (AT) gmail (DOT) com> wrote:
does the directory '/oraindx/MVSTST/' exist? is this a mount point?
is it mounted?

On 10 mai, 03:00, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:
Yes is mounted !!!

On May 9, 7:56*pm, eliot06 <p.hi... (AT) gmail (DOT) com> wrote:
You should verify that your new database has been initialized
correctly by trying to create a simple test tablespace manually. If
you get an ORA-01403 when doing so then you know that it doesn't have
to do anything with IMP but that your database is screwed up and you
probably need to start from scratch again.

If you can create a test tablespace manually, then try to repeat one
of the CREATE TABLESPACE commands failing from above literally. If
this also succeeds, you might want to trace the IMP session to find
out if IMP uses some other SQL internally that fails with the
ORA-01403 error (something that you also could do as first step).

If it turns out to be a IMP bug you might be able to workaround by
manually pre-creating the tablespaces and hoping that the remaining
steps work better.

Hope this helps,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

Co-author of the "OakTable Expert Oracle Practices" book:
http://www.apress.com/book/view/1430226684
http://www.amazon.com/Expert-Oracle-.../dp/1430226684

eliot06 wrote,on my timestamp of 10/05/2011 3:56 AM:

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.