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 ?
Thanks,