Pessoal preciso importar uma table para outro schecma e tenho o seguinte erro:
Export file created by EXPORT:V09.02.00 via direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00046: using FILESIZE value from export file of 1992294400
IMP-00047: unexpected file sequence number; expected 1 but found 3
IMP-00132: first file in the multi-file export is /u04/backup/dump/full_01_080317-2300.dmp
IMP-00000: Import terminated unsuccessfully
Meu script de export está assim:
#!/bin/bash
. /home/oracle/.bash_profile
export ORACLE_SID=NOMEDOBD
arquivo01=/p/bkp/dmp/full_01_$(date +%y%m%d-%H%M)
arquivo02=/p/bkp/dmp/full_02_$(date +%y%m%d-%H%M)
arquivo03=/p/bkp/dmp/full_03_$(date +%y%m%d-%H%M)
arquivo04=/p/bkp/dmp/full_04_$(date +%y%m%d-%H%M)
arquivo05=/p/bkp/dmp/full_05_$(date +%y%m%d-%H%M)
arquivo06=/p/bkp/dmp/full_06_$(date +%y%m%d-%H%M)
arquivo07=/p/bkp/dmp/full_07_$(date +%y%m%d-%H%M)
arquivo08=/p/bkp/dmp/full_08_$(date +%y%m%d-%H%M)
arquivo09=/p/bkp/dmp/full_09_$(date +%y%m%d-%H%M)
arquivo10=/p/bkp/dmp/full_10_$(date +%y%m%d-%H%M)
arquivo_log=/u04/bkp/dmp/full_$(date +%y%m%d-%H%M)
exp userid=username/senha file=$arquivo01,$arquivo02,$arquivo03,$arquivo04,$arq
uivo05,$arquivo06,$arquivo07,$arquivo08,$arquivo09,$arquivo10 log=$arquivo_log d
irect=y buffer=250000 full=y statistics=none filesize=1900M
cd /p/bkp/dmp
E estou utilizando o seguinte sintaxe no import
imp user/senha@NOMEDB file=name.dmp log=imp.log fromuser=antigouser touser=novouser tables=nometable buffer=500000 feedback=10000
Alguém tem alguma sugestão ???
Desde já obrigado
souza.
souza.
souza
souza
Ishii
Marcio68Almeida