1 Reply Latest reply: Sep 24, 2013 4:02 AM by DK2010 RSS

    What is the best solution for duplicating a schema tables with its data?

    c791043c-53d7-4eea-8586-e3fc035bc52b

      Hello, i'm trying to "clone" a schema tables for backup, i've tried using expdp and exp commands but when I try to import them to a new user schema, I get the TYPE duplication error, I've read that you can't do that for the TYPE issues, I've also dumping the whole table data and structure using the export database command from SQL Developer, but I keep getting errors when trying to execute the .sql file in the new Schema. Can you guys please help me with any recommendations? Thanks a lot.

       

      BTW, im using Oracle Express 11g in a Windows 7 Machine.