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 transport all of the tablespaces and all of the datafiles in the set?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---