Oracle DBA FAQ

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Oracle DBA FAQ

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


2 posters

    How to change the table name during import?

    avatar
    oradba


    Posts : 3
    Join date : 2010-02-08

    How to change the table name during import? Empty How to change the table name during import?

    Post  oradba 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.
    avatar
    Admin
    Admin


    Posts : 17
    Join date : 2010-02-08

    How to change the table name during import? Empty Re: How to change the table name during import?

    Post  Admin Tue Feb 09, 2010 12:03 am

    In 11g you can do this by using REMAP_TABLE

      Current date/time is Thu Nov 21, 2024 1:35 am