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-00002: 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-00002: 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]
