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: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 23 Dec 2004 21:12:54 -0800
Message-ID: <41cba44e$1_2@127.0.0.1>


g3000 wrote:

> Here is some background on my issue:
>
> 1. Evaluated if my tablespace set was self contained. (It was)
> 2. Exported it successfully.
> 3. Tried to import tts set but got the following
> 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 4098:
> "BEGIN sys.dbms_plugts.checkUser('FRWKDB'); END;"
> IMP-00003: ORACLE error 4098 encountered
> ORA-04098: trigger 'SYSTEM.LOG_ERRORS_TRIG' is invalid and failed
> re-validation
> ORA-29344: Owner validation failed - failed to match owner 'FRWKDB'
> ORA-06512: at "SYS.DBMS_PLUGTS", line 1490
> ORA-06512: at line 1
> . importing SAMS's objects into SAMS
> IMP-00017: following statement failed with ORACLE error 4098: ......
> blah blah
> blah..
>
> Also Metalink DocID# 100693.1 shows to DROP tablespaces delete
> datafiles for
> tablespaces then perform import.
> Which is what I attempted to do.
> The OS wouldnt allow me to delete the files after dropping the
> tablespaces. (Ive
> read this maybe on Win2k, may have to shutdown DB to delete?).
>
> Then I read where users are NOT deleting the datafiles of your
> tablespaces. I am trying to use datafile names during the import that
> are the same for the db im importing them to.
>
> DB -> export tablespace set
> same DB <- import tablespace set
>
> I dont care about the FRWKDB user just SAMS. My import command is:
> c:\oracle\ora81\bin\imp.exe
> USERID='sys/ober0n_at_samsdb AS SYSDBA'
> TRANSPORT_TABLESPACE=y
> DATAFILES=('C:\\BackupSamsDB\export\samsdb0.77274741859728\sams_interface.dbf',
> 'C:\\BackupSamsDB\export\samsdb0.77274741859728\sams_audit.dbf',
> 'C:\\BackupSamsDB\export\samsdb0.77274741859728\sams_lob.dbf',
> 'C:\\BackupSamsDB\export\samsdb0.77274741859728\sams_indx.dbf',
> 'C:\\BackupSamsDB\export\samsdb0.77274741859728\sams_tabs.dbf',
> 'C:\\BackupSamsDB\export\samsdb0.77274741859728\users.dbf')
> TABLESPACES=(sams_tabs, sams_interface, sams_audit, sams_lob,
> sams_indx, users)
> TTS_OWNERS=(sams) FROMUSER=(sams) TOUSER=(sams)
> FILE= C:\\BackupSamsDB\export\samsdb0.77274741859728\samsdb.dmp
> log=C:\BackupSamsDB\IMPORT\LOG\import_samsdb.log
> Any ideas? Did I give enough background info.
> My db is 8.1.7.4.16

What is LOG_ERRORS_TRIG?
Who built it and why?

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


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
Received on Thu Dec 23 2004 - 23:12:54 CST

Original text of this message

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