Fiz um exemplo: está no linux, mas no final é mesma coisa.
O usuário que eu exportei full o banco foi ops$marcio (DBA).
[EMAIL PROTECTED] ~]$ ls -l backup.dmp
-rw-r--r-- 1 marcio dba 131252224 May 20 18:58 backup.dmp
[EMAIL PROTECTED] ~]$ plus
SQL*Plus: Release 9.2.0.8.0 - Production on Sun May 20 18:58:54 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ops$marcio:LX92> create user teste identified by teste;
User created.
ops$marcio:LX92> grant connect, resource to teste;
Grant succeeded.
ops$marcio:LX92> revoke unlimited tablespace from teste;
Revoke succeeded.
ops$marcio:LX92> alter user teste quota unlimited on users;
User altered.
ops$marcio:LX92> alter user teste default tablespace users;
User altered.
ops$marcio:LX92> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
[EMAIL PROTECTED] ~]$ imp / file=backup.dmp fromuser=hr touser=teste
tables=regions
Import: Release 9.2.0.8.0 - Production on Sun May 20 19:02:42 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing HR's objects into TESTE
. . importing table "REGIONS" 4 rows imported
Import terminated successfully without warnings.
[EMAIL PROTECTED] ~]$
E por ai vai, voce poderia colocar mais tabelas no parametro tables=(tab1,
tab2, ...)
Agora pelo seu erro, parece que o backup.dmp não existe. Veja:
[EMAIL PROTECTED] ~]$ imp / file=nao_existe.dmp fromuser=hr touser=teste
tables=regions
Import: Release 9.2.0.8.0 - Production on Sun May 20 19:05:48 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
IMP-2: failed to open nao_existe.dmp for read
On 5/20/07, Alessandro Damo <[EMAIL PROTECTED]> wrote:
>
> Boa tarde pessoal.
>
> Fiz um exp full do banco com nome de backup.dmp, apos fazer a
> exportacao eu criei um usuario de nome "teste", agora estou tentando
> fazer um import de algumas tables do usuario "HR" para ele e nao
> consigo.
>
> Já utilizei o imp help=y para pegar informacao, mas sempre que faço a
> imp a msn IMP-2: falha ao abrir backup.dmp para leitura.
>
> Utilizo DOS, onde estou errando? alguem poderia me ajudar ?
>
> Obrigado
>
> Alessando.
>
>
>
--
Marcio Portes
Material Tecnico em Portugues - http://mportes.blogspot.com
Practical Learning Oracle -
http://mportes.blogspot.com/2006/02/practical-learning-oracle.html
[As partes desta mensagem que não continham texto foram removidas]