DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Export & Import

  1. #1
    Join Date
    Jan 2001
    Posts
    138

    Export & Import

    I have two tables STAT1 and STAT2.

    I truncated STAT2. I need to import data from STAT1.

    So, I exported table STAT1 to STAT1.dmp. (with data=yes and compress extents=yes)

    Now I need to import from STAT.dmp to STAT2 with a condition like the following.

    INSERT into STAT2 AS SELECT * FROM STAT1.dmp WHERE CURRENCY_TYPE_CD = 0 OR (ISO_CURRENCY_CD= '002' AND CURRENCY_TYPE_CD= 1)

    How do I do this with imp? Or is there a sql statement I could run. Thanks.

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    why not just:
    insert into STAT2
    select * from STAT1

    I do not think you can select from .dmp file,
    which is only readable by imp. imp only imports into same table name,
    in your case, it is STAT1.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    You can NOT seletivly import data, I sure hope you did not truncate first!

    You can try to limit your EXPORT with the *query* clause.

    http://technet.oracle.com/docs/produ...ch01.htm#34494



    Or just do as sysdba said, depending on the table size.

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    Do as sysdba has said. Plus u can add where condition for selective data.
    vishal sood
    OCP 8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width