Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Error while importing TTS on 8.1.7.4 Windows2K
Here is some background on my issue:
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
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
![]() |
![]() |