Re: Error while importing TTS on 8.1.7.4 Windows2K

g3000 wrote:
> I would like to reopen this thread please.
>
> I am having an issue that when I try to import the tablespace set it
> gives me this
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 -
> Production
> JServer Release 8.1.7.4.1 - Production
>
> Export file created by EXPORT:V08.01.07 via conventional path
> About to import transportable tablespace(s) metadata...
> import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR
> character set
> IMP-00017: following statement failed with ORACLE error 19721:
> "BEGIN
> sys.dbms_plugts.checkDatafile(NULL,2538524650,15,5120,15,15,4194302"
> ",1280,6403681,61239770,60523983,NULL,NULL,NULL,NULL); END;"
> IMP-00003: ORACLE error 19721 encountered
> ORA-19721: Cannot find datafile with absolute file number 15 in
> tablespace SAMS_INTERFACE
> ORA-06512: at "SYS.DBMS_PLUGTS", line 1626
> ORA-06512: at line 1
>
> with all other statements erroring out
> I checked the tablespace set and it was there.
>
> Could it be corrupted?

Did you specify the datafile in the command line or parameter file? Check carefully, that's what that error means.

jg

--
@home.com is bogus.
"And yes, I probably am mad." - hjr
"And in case anyone thinks I've lost my mind, well I have..." - DA
Morgan