5 Replies Latest reply on Jan 8, 2013 3:53 AM by mayuravirajjava

    Export view and import to a table

      Hi all,

      I want to export a view and import to a table in another scheme. Export data should be the data which is available at the creation of view. Import schema has a table which match this view and data should be imported to this table.
      I tried using expdp and impdp. But impdp import as normal view ( data is different when selecting from this imported view ).
      Is this possible ? If it is possible how to do this ?