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 -> Error while importing TTS on 8.1.7.4 Windows2K

Error while importing TTS on 8.1.7.4 Windows2K

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 23 Dec 2004 16:43:59 -0800
Message-ID: <1103849039.392950.310290@c13g2000cwb.googlegroups.com>


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 Received on Thu Dec 23 2004 - 18:43:59 CST

Original text of this message

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