Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error while importing TTS on 8.1.7.4 Windows2K

Re: Error while importing TTS on 8.1.7.4 Windows2K

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 6 Jan 2005 14:20:21 -0800
Message-ID: <1105050021.647819.194650@z14g2000cwz.googlegroups.com>


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? Received on Thu Jan 06 2005 - 16:20:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US