Oracle DBA FAQ

Oracle RAC interview questions, Oracle Dataguard, ASM, CRS, Oracle wait events, Performance Tuning


    How to change the table name during import?

    Share

    oradba

    Posts : 3
    Join date : 2010-02-08

    How to change the table name during import?

    Post  oradba on Mon Feb 08, 2010 11:54 pm

    I want to export a table "orders" from Production database then import it as "orders_test" in development database. (schema name is same at prod and dev.)

    Is it possible with datapump?

    Thanks in advance.

    Admin
    Admin

    Posts : 17
    Join date : 2010-02-08

    Re: How to change the table name during import?

    Post  Admin on Tue Feb 09, 2010 12:03 am

    In 11g you can do this by using REMAP_TABLE

      Current date/time is Fri May 26, 2017 8:49 am