Joel Garry wrote:
> 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
>
And pay extra attention to file #15 (see previous error
during import). It should belong to tablespace sams_interface.
I am beginning to suspect that this TS has two files (at least).
--
Regards,
Frank van Bortel
Received on Sat Jan 08 2005 - 08:59:25 CST
