No import nao, voce pode fazer no export.
Veja help em
exp help=yes
imp help=yes
e
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005843
[EMAIL PROTECTED]> host exp / file=t.dmp tables=emp query=\"where
job='SALESMAN'\"
Export: Release 10.1.0.2.0 - Production on Sat Jul 23 17:46:50 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
- Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting tableEMP 4 rows exported
Export terminated successfully with no warnings.
[EMAIL PROTECTED]> drop table emp purge;
Table dropped.
[EMAIL PROTECTED]> host imp / file=t.dmp full=y
Import: Release 10.1.0.2.0 - Production on Sat Jul 23 17:47:46 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
- Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing OPS$MARCIO's objects into OPS$MARCIO
. . importing table "EMP" 4 rows imported
Import terminated successfully without warnings.
[EMAIL PROTECTED]> select * from emp;
EMPNO ENAME JOB MGR HIREDATE
SAL
- -- - - ---
-
7499 ALLEN SALESMAN 7698 20/02/1981 00:00:00
1600
7521 WARD SALESMAN 7698 22/02/1981 00:00:00
1250
7654 MARTIN SALESMAN 7698 28/09/1981 00:00:00
1250
7844 TURNER SALESMAN 7698 08/09/1981 00:00:00
1500
4 rows selected.
--
Marcio Portes
http://mportes.blogspot.com
César wrote:
> Pessoal e possivel fazer uma query no comando imp do oracle para importação .
>
> Na tabela importada existe um campo data ?
>
>
> __
> Converse com seus amigos em tempo real com o Yahoo! Messenger
> http://br.download.yahoo.com/messenger/
>
> [As partes desta mensagem que não continham texto foram removidas]
>
>
>
> __
>
> Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
> Falar com os Moderadores:([EMAIL PROTECTED])
> Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar
> __
> Links do Yahoo! Grupos
>
>
>
>
>
>
>
>
__
Histórico: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
Falar com os Moderadores:([EMAIL PROTECTED])
Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar
__
Links do Yahoo! Grupos
<*> Para visitar o site do seu grupo na web, acesse:
http://br.groups.yahoo.com/group/oracle_br/
<*> Para sair deste grupo, envie um e-mail para:
[EMAIL PROTECTED]
<*> O uso que você faz do Yahoo! Grupos está sujeito aos:
http://br.yahoo.com/info/utos.html
