Re: Error while importing TTS on 8.1.7.4 Windows2K

g3000 wrote:
> 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.

select file#, name from v$datafile; in original and before imp, maybe that will give a clue.

Maybe those two backslashes are making a difference?

jg

--
@home.com is bogus.
"Results!  Why, man, I have gotten a lot of results. I know several
thousand things that won't work."   - Thomas Edison
"Insanity: doing the same thing over and over again and expecting
different results."  - Albert Einstein
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/optimops.htm#51246