This is what I executed
c:\oracle\ora81\bin\imp.exe USERID='sys/<snip>@samsdb AS SYSDBA'
TRANSPORT_TABLESPACE=y
DATAFILES=('C:\\BackupSamsDB\export\samsdb927309\sams_interface.dbf',
'C:\\BackupSamsDB\export\samsdb927309\sams_audit.dbf',
'C:\\BackupSamsDB\export\samsdb927309\sams_lob.dbf',
'C:\\BackupSamsDB\export\samsdb927309\sams_indx.dbf',
'C:\\BackupSamsDB\export\samsdb927309\sams_tabs.dbf',
'C:\\BackupSamsDB\export\samsdb927309\users.dbf')
TABLESPACES=(sams_tabs, sams_interface, sams_audit, sams_lob,
sams_indx, users)
FROMUSER=(sams) TOUSER=(sams)
FILE= C:\\BackupSamsDB\export\samsdb927309\samsdb.dmp
log=C:\BackupSamsDB\IMPORT\LOG\import_samsdb.log
and yes this is the entire set not part. I will do the entire set each
time.
The entire set contains 1 application schema and users who have no db
access only through app owner.
Received on Fri Jan 07 2005 - 09:49:28 CST
