user10450258 wrote:create table schema2.table_name as select * from schema1.view_name ? with appropriate privileges, it is as simple as that.
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 ?