Re: Import full oracle 8.1.7
Date: Tue, 10 May 2011 01:37:36 -0700 (PDT)
Message-ID: <efa4fcd1-5d5c-4088-82f8-73fbe901ed09_at_h9g2000yqk.googlegroups.com>
On May 9, 7:56 pm, eliot06 <p.hi..._at_gmail.com> wrote:
> and when I do full import I have lots of error like below :
>
> 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
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-Practices-Database-Administration/dp/1430226684 Received on Tue May 10 2011 - 03:37:36 CDT